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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between Target-based loading and constraint-based loading?

1042


Could you explain what is enterprise data warehouse?

1224


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2403


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8263


What are pre and post-session shell commands?

1387


How can we create index after completion of load process?

1165


What do you mean by blocking transformation?

1118


What do you mean by worklet?

1114


Does an informatica transformation support only aggregate expressions?

1086


What is decode in static cache?

1261


What is a connected transformation?

1183


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

2093


Performance tuning in UNIX for informatica mappings?

2623


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

1165


What are the designer tools for creating transformations?

1158