Geeks Talk

Prepare for your Next Interview




repeating the records in the output table ...

This is a discussion on repeating the records in the output table ... within the Data Warehousing forums, part of the Databases category; I am handling an oracle table in datastage. I want to put all data from this into another table/file where each record will be just repeated certain number of ...


Go Back   Geeks Talk > Databases > Data Warehousing

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 10-26-2007
Junior Member
 
Join Date: Oct 2007
Location: Chennai
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
rathin007 is on a distinguished road
repeating the records in the output table ...

I am handling an oracle table in datastage. I want to put all data from this into another table/file where each record will be just repeated certain number of times(fixed or variable). How can I do that ?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 10-26-2007
Moderator
 
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,483
Thanks: 8
Thanked 128 Times in 115 Posts
debasisdas will become famous soon enoughdebasisdas will become famous soon enough
Re: repeating the records in the output table ...

You simply need to insert the records by selection from the table to another table. Repeat the process as many number of times you want to complete teh process. Don't forget to commit after completition of every process.
Reply With Quote
  #3 (permalink)  
Old 10-26-2007
Junior Member
 
Join Date: Oct 2007
Location: Chennai
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
rathin007 is on a distinguished road
Re: repeating the records in the output table ...

Thanks , but I am not clear what you said.I am explainig again my querry

Suppose my table has two rows , three columns. Now by passing this through a Transformer stage , I am adding another column to it , with values ( let 2 & 3) in the row 1 & row 2 respectively. So my table has now 2 rows & 4 columns.Now I want to pass this table to another stage so as to create a new table table which will have each row repeated the number of times as in the new column (2 & 3) , so that my final table will have in total 5 rows , 2 same rows & 3 same rows . Remember these values 2 & 3 are not fixed , it depends on the values in the original table.
What must be that stage & how to proceed?
Reply With Quote
Reply

  Geeks Talk > Databases > Data Warehousing


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
How many records in output Geek_Guest SQL 7 11-10-2007 01:30 AM
How to retrieve top 10 records from ORACE Table ppooven Oracle 2 07-12-2007 07:49 AM
Get records from table month, day, year wise. Geek_Guest DB2 2 06-12-2007 04:22 AM
I want to load odd number records into one target table ggk.krishna Data Warehousing 2 04-18-2007 12:22 AM
I want load the duplicate records to seperate table Geek_Guest Data Warehousing 4 04-06-2007 03:10 AM


All times are GMT -4. The time now is 01:56 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved