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


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?

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

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,


How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  


We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  


What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,


what is constraint based load order

2 Answers   Cap Gemini,


How can you complete unrcoverable sessions?

1 Answers  


we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,


Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,


What does role playing dimension mean?

0 Answers  


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,


Categories