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

suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?

Answer Posted / shankar

SQ---->AGR---->RTR---->TGT
SEQ--->RTR

1) Pass all records to Agr
In AGR take count port ion taht give count(empno)
2)Next create SEQQUENCE GENERATOR connect nexval to router
3) Int RTR Create one Group called 1st half
In that give nextval<=count/2
4) Connect to TGTs from 2 groups (1st half and Default)

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you generate sequence numbers without using the sequence generator transformation?

1081


How can you validate all mappings in the repository simultaneously?

1322


How to use pmcmd utility command?

994


what is mean by complex business rule ?

2133


Explain the types of transformations?

1034


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

1091


write a query to retrieve the latest records from the table sorted by version(scd)

1033


What is meant by a domain?

1102


difference between informatica 8.1.1 and 8.6

3647


What is the maplet?

1073


How do you convert single row from source into three rows into target?

1117


Explain the features of connected and unconnected lookup.

907


How to configure mapping in informatica?

1143


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2277


What are the types of lookup transformation?

1042