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


Please Help Members By Posting Answers For Below Questions

What are the functionalities of link collector?

870


What is ds designer?

874


Explain the situation where you have applied SCD in your project?

1810


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2947


What are routines in datastage? Enlist various types of routines.

879


What is the difference between account and directory options ?

904


Can you explain how could anyone drop the index before loading the data in target in datastage?

1256


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

571


What is a datastage job?

818


Is it possible to query a hash file?

1790


Can you filter data in hashed file?

3586


Can you explain link buffering?

950


What is active and passive stage?

1181


Explain Quality stage?

923


What is the purpose of interprocessor stage in server jobs?

1988