i having source, router transformation, two targets in my
mapping... i given two conditions in router
1)sal >500
2)sal < 5000
---------------
my source is havig two sal records (1)1000 (2)2000
then which target will load first? will both targets are get
load or single target only get load...... why?

Answer Posted / sameer

according to router group condition first load data the into target sal<500 and then load the data into the target sal<5000 because the informatica server check the group condtion according to router group then load then the data into the target means in target t1 1000 and then load taeget t2 5000

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica powercenter repository?

698


What does role playing dimension mean?

609


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

546


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

1683


server hot-ws270 is connect to Repository B. What does it mean?

1843






what is degenerated dimension?

3136


Can anyone tell me the new features in Informatica 9 Version?

1516


How can we use mapping variables in informatica? Where do we use them?

605


How to load the data from people soft hrm to people soft erm using informatica?

548


Did u used latest transformations of 8.6.0? for what?

1464


expain about the tune parameters?

1867


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1691


Clarify the utilization of aggregator cache record?

566


How to start a workflow using pmcmd command?

697


What is blocking transformation?

700