how can you generate sequence number using only the sequential
file stage?
- 3 Answers
- 15634 Views
- TIAA CREF, I also Faced
- E-Mail Answers
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 |
How many types of sorting methods are available in datastage?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
What all the types of jobs you developed?
What are the different plug-ins stages used in your projects?
What are the various kinds of the hash file?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are datastage sequences?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
How can we run same job in 1 day 2 times
what is advantages of snowflake when it is used?
Differentiate between Join, Merge and Lookup stage?
Teradata 
