Interested to Buy Any Domain ? << Click Here >> for more details...
how can you generate sequence number using only the sequential
file stage?
- 3 Answers
- 17547 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
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what is the use of skid in reporting?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
describe the Steps to confiure a Qlogic switch
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the processing stages?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Difference between sequential file and data set?
How many types of hash files are there?
Is possible to create skid in dim,fact tables?
How a server job can be converted to a parallel job?
What is the differentiate between data file and descriptor file?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How can you write parallel routines in datastage PX?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
