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 is the difference between server job and parallel jobs?

913


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2010


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2035


What is the difference between an operational datastage and a data warehouse?

871


What are the processing stages?

855


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2226


What is the difference between validated and compiled in the datastage?

903


what is use of SDR function?

4918


If you want to use a same piece of code in different jobs, how will you achieve this?

1048


What is the difference between datastage and datastage tx?

820


What are iconv and oconv?

991


Distinguish between informatica & datastage. Which one would you choose and why?

767


What is merge stage?

982


What is the use of datastage director?

798


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2970