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?
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 |
Describe the architecture of datastage?
I have a few records just I want to store data in to targets cycling way how?
What are the repository tables in datastage?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the importance of the exception activity in datastage?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
how to configure databases through datastage
What are the different common services in datastage?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?