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.
Answers were Sorted based on User's Feedback
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 |
Answer / venki
Hi
source ->copy- funnel -target
here copy the out put link to funner 5 times it will work
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ankit gosain
Hi All,
Well you can create a job with O/P file in Append mode,
like:
I/P Seq file----->O/P Seq file
and use it under a Sequence Activity with Start Loop and
End loop activity like.
Start Loop---->Sequence1---->End Loop
| |
|-------------------------|
Start Loop properties:
---------------------
From=1
to=5
Spet=inc
In this way the job will be executed for the 5 times and
you will get the desired O/P.
Cheers,
Ankit :)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shailesh
simplest solution that i can think of using ds8.1 pivot satge
seqfile--->pivot--->target
in pivot stage give the derivation for new_col as old_col,old_col,old_col,old_col,old_col (five times)
map it to target you will get the desired output
| Is This Answer Correct ? | 0 Yes | 0 No |
Define APT_CONFIG in Datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the benefits of datastage?
what is factless fact table?
whom do you report?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
how to sort two columns in single job in datastage.
Explain ibm infosphere information server and highlight its main features?
why we use parameters instead of hard code in datastage
explain about citrix scheduling tool in datastage
how to transfer file from one system to another system in unix? which cmd to be use?