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 |
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the use of hoursfromtime() function in transformer stage in datastage?
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.
What is the sortmerge collector?
Can we use target hash file as a lookup ?
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
What are some prerequisites for datastage?
What are the prerequisites for join stage
what is datastage job Monitoring
If you want to use the same piece of code in different jobs, how will you achieve it?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
What is the importance of the exception activity in datastage?