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 |
how to validate the jobs
What is job control?
What is usage analysis in datastage?
How do you generate sequence number in datastage?
which cache supports connected & un connected Lookup
what is the use of materialized view?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How to remove blank spaces from data?
Explain entity, attribute and relationship in datastage?
What is the command line function to import and export the ds jobs?
what is the use of skid in reporting?
Triggers,VIEW,Procedures