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

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2055


What if the source is a flat-file?

1168


How can we delete duplicate rows from flat files?

1308


How to generate sequence numbers?

1132


Explain Dataware house architecture .how data flow from intial to end?

2647


Why update strategy and union transformations are active? Explain with examples.

1284


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.

2347


Describe data concatenation?

1125


Can anyone tell me the new features in Informatica 9 Version?

2207


can anyone explain me about retail domain project in informatica?

7998


Mention some types of transformation?

1096


What is joiner change?

1191


What is meant by LDAP users?

1287


State the differences between sql override and lookup override?

1283


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4150