how can you generate sequence number using only the sequential
file stage?
Answers were Sorted based on User's Feedback
Answer / ankit gosain
Hi All,
Open you Sequential File then
Output>Properties>Options>RowNumberColum and name the
column as SeqNumber.
And don't forget to add SeqNumber to the Column Definitions.
Otherwise, if RCP is disabled, DataStage will drop that
column.
If you have more queries, you can mail me on
ankitgosain@gmail.com
Cheers,
Ankit :)
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / revanth
Use the row number column in options of sequential file.
| Is This Answer Correct ? | 3 Yes | 1 No |
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
what are fact tables and dimension tables? give example assuming one table.
How we can covert server job to a parallel job?
How to initialize environment variables?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
How did you reconcile source with target?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
Notification Activity
What are the different layers in the information server architecture?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
What are the functionalities of link collector?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?