Interested to Buy Any Domain ? << Click Here >> for more details...
how can you generate sequence number using only the sequential
file stage?
- 3 Answers
- 17442 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 |
What are sequencers?
i have flat file and using unix how can i generate sequence number into targer?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the use of datastage designer?
where we use config file as parameter ?
What is exact difference between Parallel Jobs and server Jobs..
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?
Differentiate between datastage and datastage tx?
Why do we use exception activity in Datastage?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
What is difference between 8.1 , 8.5 and 9.1 ?
Teradata 
