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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a filter transformation and why it is an active one?

909


Is stop and abort are same in informatica?

949


What is target designer and target load order?

1053


What is a joiner transformation and why it is an active one?

1000


scenario where i can use only concurrent execution of workflow.

3067


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1977


complex mapping ur project u r invlve can u explain and give real time example give me ?

2237


generate date / time dimension in informatica

1073


How are the sources and targets definitions imported in informatica designer?

1052


What is sq transformation?

1082


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1017


COM components can be used in Informatica

2315


What are the main features of Oracle 8i with context to datawarehouse?

2053


What can we do to improve the performance of informatica aggregator transformation?

1045


What is a repository manager?

1030