Interested to Buy Any Domain ? << Click Here >> for more details...
how can you generate sequence number using only the sequential
file stage?
- 3 Answers
- 17430 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
What is a merge?
What are the different types of lookups in datastage?
What is apt_config in datastage?
What all the types of jobs you developed?
Explain how a source file is populated?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
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 different layers in the information server architecture?
What are the components of datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is datastage engine?
What is a quality stage in datastage tool?
what is flow of project?
What are the difference types of stages?
options available in sequence job to run,validate?
