Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  


What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  


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.

4 Answers   Amdocs,


What is the sortmerge collector?

0 Answers  


Can we use target hash file as a lookup ?

0 Answers  


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?

1 Answers   Hexaware,


What are some prerequisites for datastage?

0 Answers  


What are the prerequisites for join stage

2 Answers  


what is datastage job Monitoring

6 Answers   CTS,


If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  


i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,


What is the importance of the exception activity in datastage?

0 Answers  


Categories