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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?

Question Posted / siva reddy

Answers were Sorted based on User's Feedback



100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / manthiramoorthy. g

SQ-->EXP-SEQ-RTR-TARGETS

Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2

Is This Answer Correct ?    13 Yes 2 No

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / mayur

SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target

Is This Answer Correct ?    1 Yes 0 No

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / chandra

SQ--->EXP-->ROUTER---->TARs


In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

Is there any model difference between ODS and DWH

2 Answers   Zensar,

Can you copy the batches?

3 Answers  

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

What is olap (on-line analytical processing?

0 Answers  

For more Informatica Interview Questions Click Here
Categories