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

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,


How do u convert the columns to rows in datastage?

0 Answers  


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?

0 Answers  


which r the connectors used in san?

0 Answers  


How do you register plug-ins?

0 Answers  


What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,


what is initial load and incremental load

3 Answers   ADP,


How to perform incremental load in datastage?

0 Answers  


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.

0 Answers  


What are the types of views in datastage director?

0 Answers  


what about data stage requirement

1 Answers  


Categories