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
Explain lookup transformation source types in informatica
What do you understand by term role-playing dimension?
what are the deliverables?in your project?
What is deployment group?
What do you mean by channel change?
What's the layout of parameter file (what does a parameter file contain?)?
What is data transformation manager process?
What is a transaction control transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is the function of aggregator transformation?
Mention a few design and development best practices for informatica?
what is mean by complex business rule ?
What is domain and gateway node?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Briefly describe lookup transformation?