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
can u any challenge your project?
Describe the impact of several join conditions and join order in a joiner transformation?
What is event and what are the tasks related to it?
In development project what is the process to follow for an etl developer from day1
Can we create a node as a gateway node and the same node can be assigned to a grid?
How many ways a relational source definition can be updated and what are they?
What are ETL Tools?
What is workflow? What are the components of workflow manager?
In informatics server which files are created during the session rums?
Partition, what happens if the specified key range is shorter and longer
What is the difference between a connected look up and unconnected lookup?
What are the different types of repositories created using informatica?
In which transformation you cannot drag ports into it?
How can you increase the performance in joiner transformation?
What is the difference between Active and Passive transformation?