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
- 13112 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 is substr in informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What does role playing dimension mean?
What all are steps in up gradation of Informatica server?
How does a sorter cache works?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Differentiate between joiner and lookup transformation?
What do you mean incremental aggregation?
If informatica has its scheduler why using third party scheduler?
How do you migrate data from one environment to another?
What is informatica powercenter repository?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is joiner transformation in informatica?
What is aggregator transformation in informatica?
