how to design mapping half of source table records into one
target and remaining half into another target

Answer Posted / sbvp

S->SQ->EXP->ROUTER->TRG
| |
| |-->TGR
SEQ<-

IN RTR SEQ<=n
SEQ>=n

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2133


How to use pmcmd utility command?

579


What is union transformation?

570


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1691


What is an aggregator transformation?

615






what is $$$$?

1735


How many ways a relational source definition can be updated and what are they?

576


In informatica workflow manager, how many repositories can be created?

778


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5244


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

628


In informatics server which files are created during the session rums?

633


In warehouses how many schemas are there?

582


Explain about Informatica server process that how it works relates to mapping variables?

619


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1494


Why do you use Mapping Parameter and mapping variable?

1281