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 are the limitations of joiner transformation?

1093


In informatics server which files are created during the session rums?

1109


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1890


have u done any performance tuning? how u ll do?

2281


What is workflow? What are the components of the workflow manager?

1112


what is unit testing?tell me proceedure

2206


What is workflow? What are the components of workflow manager?

1161


What is domain and gateway node?

1155


Explain the code page compatibility?

1052


Why do we need informatica?

975


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1176


What is the status code in stored procedure transformation?

1170


What do you mean by blocking transformation?

1017


What are the mapping parameters and mapping variables?

1161


tell me the rules and responsblites in our project(my project is development)

1920