1)Source file contains one record, I want 100 records in
target file.

Answers were Sorted based on User's Feedback



1)Source file contains one record, I want 100 records in target file...

Answer / subhash

Another best way is:
SRC--->TFM--->TGT
in TFM, we can do this by using LOOPing concept.
@ITERATION<=100
map the SRC record to TGT.

Is This Answer Correct ?    10 Yes 0 No

1)Source file contains one record, I want 100 records in target file...

Answer / ramachandra rao

This Question has two types of answers
1.after source take copy stage after that use funnel stage
and finally use target.copy stage stage allows many output
links after that use funnel stage.and target keep append
mode and u run 100 times 100 records displayed.
2)
u develop the job and kept into sequence with start loop and
end loop.but in in job target has append mode.in loop u give
initial value and increment value and max value.

This is the best answer.

Is This Answer Correct ?    8 Yes 0 No

1)Source file contains one record, I want 100 records in target file...

Answer / salendra

By usng pivot stage it can be solved

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More Data Stage Interview Questions

What is difference between server jobs & parallel jobs?

0 Answers  


1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,


Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,


what is operator combinality in datastage?

1 Answers   TCS,


How many types of sorting methods are available in datastage?

0 Answers  


if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,


What is APT_DUMP_SCORE?

2 Answers   IBM,


diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,


How many types of stage?

0 Answers  


5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  


how to closeing records after 10,000 records come?

3 Answers  


how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,


Categories