source file contains 100 records, i want 10 records in
target file how it possible in datastage
Answer Posted / vamsi
take source --->trf---->trg
in transformer constaints put inrownum <=10
then u can get the required answer.........
Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
how to sort two columns in single job in datastage.
Define orabulk and bcp stages?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the difference between account and directory options ?
What are the components of ascential data stage?
What is the importance of the exception activity in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
Difference between sequential file and data set?
Define data aggregation?
Differentiate between datastage and informatica?
What are sequencers?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are some different alternative commands associated with "dsjob"?
Different ways a project can be moved to production ?...example ….export-import and Version control.
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.