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 are the functionalities of link collector?
What is ds designer?
Explain the situation where you have applied SCD in your project?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are routines in datastage? Enlist various types of routines.
What is the difference between account and directory options ?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is a datastage job?
Is it possible to query a hash file?
Can you filter data in hashed file?
Can you explain link buffering?
What is active and passive stage?
Explain Quality stage?
What is the purpose of interprocessor stage in server jobs?