Interested to Buy Any Domain ? << Click Here >> for more details...
suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
- 9 Answers
- 13352 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gvk
SQ--->AGG SEQ
SOURCE ----->JOINER---->ROUTER---->TARGET1 AND TARGET2
SQ--->EXP
HERE AGG:1. CT---[O]--->COUNT(EMPNO)
2. NEWPORT---[O]--->1
EXP:1.NEWPORT----[O]---->1
JOINER:NEWPORT(EXP)=NEWPORT(AGG)
ROUTER: GROUP1--->NEXTVAL<=ROUND(CT/2)
GROUP2--->NEXTVAL>ROUND(CT/2)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain pushdown optimization $pushdownconfig parameter - informatica
How many ways are there to create ports?
What is domain and gateway node?
what is the size of u r source(like file or table)?
Different qualification between a related rotate toward the sky and isolates look upward?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain why we use partitioning the session in informatica?
What are ETL Tools?
How to extract sap data using informatica?
What is joiner transformation in informatica?
What is Data Caches size?
How to open an older version of an object in the workspace?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Can we override a native sql query within informatica?
