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



Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel ..

Answer / subhash

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

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel ..

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

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel ..

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

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel ..

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

Post New Answer

More Data Stage Interview Questions

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?

0 Answers   HCL,


what is the use of surogate key in datastage

0 Answers   TCS,


what is flow of project?

0 Answers   HSBC, IBM,


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,


i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  






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

4 Answers   IBM, PR3 Systems,


How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 Answers  


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?

1 Answers   Wipro,


How to implement complex jobs in data stage?

0 Answers  


How to find value from a column in a dataset?

0 Answers   TIAA CREF,


Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,


How many number of reject links merge stage can have?

7 Answers   TCS,


Categories