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?
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 are the databases that informatica can connect to windows?
where to store informatica rejected data?
What are connected or unconnected transformations?
Explain pmcmd command usage in informatica
Briefly define reusable transformation?
Clarify the utilization of aggregator cache record?
How you prepared reports for OLAP?
What will be the approach?
Enterprise data warehouse your projects phase by phase explain?
Explain sessions. Explain how batches are used to combine executions?
Describe an informatica powercenter?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Performance tuning( what you did in performance tuning)
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Differentiate between joiner and lookup transformation?