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 |
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
what is the use of surogate key in datastage
what is flow of project?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
i have the source from Uk,north america how can i pass the data two tables based on the locations
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
How to implement complex jobs in data stage?
How to find value from a column in a dataset?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
How many number of reject links merge stage can have?