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 |
What are the functionalities of link partitioner and link collector?
can any one tell me how to install datastage 8.1 in windows xp with wizard
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
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?
Difference between in process and inter process?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
Nls stands for what in datastage?
how can or from where we can get reference data in scd type2 implementation?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
i have flat file and using unix how can i generate sequence number into targer?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.