how can you generate sequence number using only the sequential
file stage?
- 3 Answers
- 16571 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 |
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
What is difference between symmetric multiprocessing and massive parallel processing?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
how to design the change capture stage in(data stage parallel jobs) type 2
what is hash file
Define repository tables in datastage?
What is the difference b/w Hash file and Lookup Fileset stages?
What is the project in datastage?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
What is size of a transaction and an array means in a datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
how to sort two columns in single job in datastage.
Teradata 
