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

How can i send first half of the records to one target and
Remaining to other target?

Answer Posted / gvk

Here

SOURCE------>SQ--->AGG---> SEQ\ /T1
----->JOINER----->ROUTER----
SOURCE------>SQ--->EXP---> \T2


THIS IS THE PROCESS
HERE AGG--->TWO PORTS 1)NEW PORT 2)COUNT PURPOSE
EXP---->1)NEW PORT ONLY
JOINER-->COMPARE TO THE (AGG & EXP) NEW PORTS AND
APPLY THE FULL JOIN
ROUTER--->TWO CONDITIONS

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can u any challenge your project?

2038


Describe the impact of several join conditions and join order in a joiner transformation?

1063


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

1124


In development project what is the process to follow for an etl developer from day1

1727


Can we create a node as a gateway node and the same node can be assigned to a grid?

1085


How many ways a relational source definition can be updated and what are they?

1019


What are ETL Tools?

1128


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

1181


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

1125


Partition, what happens if the specified key range is shorter and longer

2504


What is the difference between a connected look up and unconnected lookup?

972


What are the different types of repositories created using informatica?

1145


In which transformation you cannot drag ports into it?

1326


How can you increase the performance in joiner transformation?

1202


What is the difference between Active and Passive transformation?

1163