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 the purpose of pivot stage?
State the difference between an operational datastage and a data warehouse?
What can we do with datastage director?
What is the use of datastage designer?
What are the job parameters?
What is use Array size in datastage
Explain ibm infosphere information server and highlight its main features?
Explain how a source file is populated?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
If you want to use a same piece of code in different jobs, how will you achieve this?
Differentiate between operational datastage (ods) and data warehouse?
I have a few records just I want to store data in to targets cycling way how?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What all the types of jobs you developed?
How rejected rows are managed in datastage?