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

i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2.

Question Posted / jagadabhi.hima

Answers were Sorted based on User's Feedback



i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

Answer / abpat2203

Add a sequence generator. Next, pass the all the data along
with that from the sequence generator into a router.

In the router, use the mod fucntion on the value incoming
from sequence generator.

If the mod fucntion returns a 0, pass it to T2 and if it
returns any other value other than 0, pass it into T1.

Is This Answer Correct ?    14 Yes 0 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

Answer / akash

By using Router Transformation
SQL Server : (id%2 = 0 or 1)
Oracle : mod(id,2) = 0 or 1

Is This Answer Correct ?    0 Yes 0 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and..

Answer / usha

seq g
|
|
s-->sq--->RTR

in router netval=1
nextvale=2

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

What is a node in Informatica?

0 Answers  

What is InformaticaPowerCenter?

0 Answers   Informatica,

What is rank transformation in informatica

0 Answers   Informatica,

Explain the pipeline partition with real time example?

0 Answers   Informatica,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

what is the flow?

1 Answers  

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

what is lookup chache?

1 Answers   Patni,

What are the databases that informatica can connect to windows?

0 Answers  

For more Informatica Interview Questions Click Here
Categories