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
What are active and passive transformations?
What is the scenario which compels informatica server to reject files?
How do you take back up of repository?
What is fact table? Explain the different kinds of facts.
draw informatica architecture 8.6 ?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How we can create indexes after completing the load process?
What are the components of workflow manager?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Make a note of the quantity vaults made in informatica?
how to load dimension table and fact table. plz tell me the steps.
What is the difference between informatics 7x and 8x and what is latest version?
can u give example for factless fact table
Explain sessions. Explain how batches are used to combine executions?
What is a transaction control transformation?