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

Define sessions in informatica etl?

702


what is informatica metadata?

692


How to elaborate tracing level?

789


Slowly changing dimensions, types and where will you use them

1363


During the running session, output files are created by informatica server. Enlist few of them.

627






What are Dimensional table?

691


Explain the different lookup methods used in informatica?

686


What are the basic requirements to join two sources in a source qualifier transformation using default join?

697


How you prepared reports for OLAP?

1248


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1621


How to go to the older version for a mapping?

688


Write the unconnected lookup syntax and how to return more than one column.

699


Please let me know how to make encryption and decryption with example?

1571


How an expression transformation differs from aggregator transformation?

709


What is a standalone command task?

775