Interested to Buy Any Domain ? << Click Here >> for more details...
how can you generate sequence number using only the sequential
file stage?
- 3 Answers
- 17431 Views
- TIAA CREF, I also Faced
- E-Mail Answers
Answer Posted / revanth
Use the row number column in options of sequential file.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you generate sequence number in datastage?
what is the use of surogate key in datastage
What is the use of hoursfromtime() function in transformer stage in datastage?
How many types of views are there in a datastage director?
What are the enhancements made in datastage 7.5 compare with 7.0?
what is use of SDR function?
What is meta stage?
Describe routines in datastage? Enlist various types of routines.
What is difference between symmetric multiprocessing and massive parallel processing?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the different options associated with dsjob command?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Differentiate between validated and Compiled in the Datastage?
Why fact table is in normal form?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
