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 |
1.what is materialized data? 2.how to view the materialized data?
How do u convert the columns to rows in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
Explain usage analysis in datastage?
which r the connectors used in san?
How do you register plug-ins?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
what is initial load and incremental load
How to perform incremental load in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the types of views in datastage director?
what about data stage requirement