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 ds administrator used for?
What are the some differences between 7.x and 8.x version of datastage?
Why we use surrogate key?
Can you explain kafka connector?
Explain the situation where you have applied SCD in your project?
What are stage variables, derivations and constants?
What is data partitioning?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Explain entity, attribute and relationship in datastage?
what is use of SDR function?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Explain usage analysis in datastage?
How many types of sorting methods are available in datastage?
Describe link sort?
Is it possible to query a hash file?