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 flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details

Answer Posted / jay

SCR-->SQ-->AGGR-----
| |
| v TRG 1
--------->RTR--> /
/ \
SEQ TRG 2

First get the count of records using Aggr t/r
and use this result in router t/r and have
router condition as SEQ < (Count / 2) for TRG 1
and default for TRG 2

Is This Answer Correct ?    9 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1094


Explain the difference between a data warehouse and a data mart?

1066


What is event and what are the tasks related to it?

1126


According to his methodology what all you need before you build a datawarehouse

1765


How might one distinguish in the case of mapping is right or not without associating session?

1139


How to extract sap data using informatica?

1054


What is informatica etl tool?

1007


What is dimensional table?

1077


What do you understand by term role-playing dimension?

1062


What is an Integration service in Informatica?

1144


Enlist some properties of sessions.

1095


Write the prerequisite tasks to achieve the session partition?

1171


What are the differences between source qualifier and joiner transformation?

1072


What are the designer tools for creating transformations?

1127


What is main use of mapplet?

1145