SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN
TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE
THERE?WHAT LOGIC?
Answer Posted / subhash
1)
JOB1: SRC---->COPY---->TGT
SEQuence:
START LOOP---->JOB1----->END LOOP Activity.
In TGT stage use 'Append' Mode.
By Looping 100 time, we can get 100 records in target.
2)
SRC---->Transformer---->TGT
By using Looping Variable in the Transformer, we can achieve
this.
Loop While Condition "@ITERATION <=100"
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the different common services in datastage?
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 the enhancements made in datastage 7.5 compare with 7.0?
CHANGE CAPTURE
What is the different type of jobs in datastage?
what is use of SDR function?
How do you import and export the datastage jobs?
What all are the different way to run a job?
How rejected rows are managed in datastage?
Explain ibm infosphere information server and highlight its main features?
What are the functionalities of link collector?
What all the types of jobs you developed?
What steps should be taken to improve Datastage jobs?