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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What if the source is a flat-file?
How can we delete duplicate rows from flat files?
How to generate sequence numbers?
Explain Dataware house architecture .how data flow from intial to end?
Why update strategy and union transformations are active? Explain with examples.
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.
Describe data concatenation?
Can anyone tell me the new features in Informatica 9 Version?
can anyone explain me about retail domain project in informatica?
Mention some types of transformation?
What is joiner change?
What is meant by LDAP users?
State the differences between sql override and lookup override?
can any one give some examples for pre sql and post sql(Except dropping and creating index).