Interested to Buy Any Domain ? << Click Here >> for more details...
how can you generate sequence number using only the sequential
file stage?
- 3 Answers
- 17207 Views
- TIAA CREF, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define project in datastage?
How do y read Sequential file from job control?
What steps should be taken to improve Datastage jobs?
What is a folder? Difference types of stages?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is apt_config in datastage?
Define Job control?
What is ibm datastage flow designer?
What is the different type of jobs in datastage?
How many types of views are there in a datastage director?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the some differences between 7.x and 8.x version of datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the difference types of stages?
How many areas for files does datastage have?
