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
- 13051 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
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What can we do to improve the performance of informatica aggregator transformation?
Explain dynamic target flat file name generation in informatica
What's the layout of parameter file (what does a parameter file contain?)?
Explain why we use partitioning the session in informatica?
What is the Process to creating lookup transformation in informatica
Write the program through which the records can be updated?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Slowly changing dimensions, types and where will you use them
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is a rank transform?
How do you convert single row from source into three rows into target?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to join three sources using joiner? Explain though mapping flow.
