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 |
Describe link sort?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How to remove duplicates in transformer stage? in parallel mode
options available in sequence job to run,validate?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
How many types of views are there in a datastage director?
What is the use of datastage designer?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
is it possible to access the same job by two users at a time in DataStage?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
what is ds administrator used for?
How did you reconcile source with target?