Hi every one, I am Suneel.

I/p o/p
--- -----
suneel suneel
suneel
suneel
suneel
suneel

how it will get.
Please design job with explain.

Thanks.

Answer Posted / subhash

1. SRC---->TFM---->TGT
in the TFM, by using Looping we, can do this.
@ITERATION<=5

2.SRC---->COPY===>(5copies/links)==>FUNNEL---TGT

take 5 output links from copy stage, pass those to Funnel
then you will get the desired output.

3. SRC--->TGT
run the job 5 time in 'APPEND' mode

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functionalities of link partitioner and link collector?

594


What are some prerequisites for datastage?

616


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2839


What is merge stage?

760


what is 'reconsideration error' and how can i respond to this error and how to debug this

2117






Where do the datastage jobs get stored?

728


What is staging variable?

622


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2726


Name the command line functions to import and export the DS jobs?

705


Can you explain link buffering?

724


Why do we use exception activity in Datastage?

710


What are the different common services in datastage?

705


CHANGE CAPTURE

889


How many types of views are there in a datastage director?

832


How do you run datastage job from the command line?

596