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

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. what is the procedure and whar t/r's are involved
and what is the mapping flow

Answer Posted / vani

Can it be done in this way....

1)Drag source to mapping designer
2)Take a router transformation .consider EMP table in which
i am using EMPNO. In group1, assign the condition as
mod(empno,2)=0 which gives even numbers and in group2,
assign the condition as mod(empno,2)!=0 which gives odd numbers.
3)connect group1 to one target and group2 to another target.

If i am wrong please tell me....

Is This Answer Correct ?    27 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps involved in the migration from older version to newer version of Informatica Server?

2106


Can you use flat files in Mapplets.

2648


Explain in detail scd type 2 through mapping.

1041


Explain the mapping variable usage example in informatica

1157


Define mapping and session?

1033


What is informatica worklet?

1066


What are the new features of informatica 9.x in developer level?

998


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7062


How to do unit testing in informatica? How to load data in informatica ?

1120


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2395


where to store informatica rejected data?

1093


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012


How to configure mapping in informatica?

1173


What is the function of union transformation?

1134


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1199