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 |
What is the differentiate between data file and descriptor file?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
what is diff b/w datastage 8.1,8.5,8.7?
How do you start developing a datastage project?
options available in sequence job to run,validate?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
I have a few records all are same structures data, I want to store data in multiple targets how?
How can u write exception handling in seq file????
What is orabulk stage?
Is it possible to query a hash file?
how can you generate sequence number using only the sequential file stage?