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 / jvdwhinfo

Hi Guys,

Both the targets are loaded with both the records as both
condition are satisfied.
And the order of loading is, first target 1 is loaded and
next target 2 is loaded as informatica loads target by
target.

Thanks.
James

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between router and filter?

627


What are the features of complex mapping?

616


What is the use of target designer?

581


how to load dimension table and fact table. plz tell me the steps.

1663


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1527






What is Index Caches size?

595


my source is junk data how will u remove that junk data by using unix please any one replay me

3213


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7735


Why update strategy and union transformations are active? Explain with examples.

680


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1596


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1606


How many ways are there to create ports?

686


How many input parameters can exist in an unconnected lookup?

961


Differentiate between source qualifier and filter transformation?

968


Design a mapping to load a target table with the following values from the above source?

851