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

Explain grouped cross tab?

1 Answers   Accenture,

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

what are presession,postsession success and postsession failure commands ?

1 Answers  

what is hash table in informatica?

1 Answers   Zensar,

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

What are active and passive transformations?

0 Answers   Informatica,

Enlist the advantages of informatica.

0 Answers  

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

what is data driven?

5 Answers   TCS, Wipro,

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories