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 |
Explain entity, attribute and relationship in datastage?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
Define repository tables in datastage?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
Wat is isolation level and when do u use them?
How to implement complex jobs in data stage?
i have flat file and using unix how can i generate sequence number into targer?
can we use sequential file as a lookup
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
What are the types of containers in datastage?