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 difference between server job and parallel jobs?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
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
What is the difference between an operational datastage and a data warehouse?
What are the processing stages?
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
What is the difference between validated and compiled in the datastage?
what is use of SDR function?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the difference between datastage and datastage tx?
What are iconv and oconv?
Distinguish between informatica & datastage. Which one would you choose and why?
What is merge stage?
What is the use of datastage director?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also