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 sequence generator transformation in informatica?

714


Is it possible to create multiple domains on a single Informatica server?

869


Sequence generator, when you move from develoment to production how will you reset

1527


What are the types of schemas we have in data warehouse and what are the difference between them?

615


What is Data Caches size?

736






Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1674


What is the procedure for creating independent data marts from informatica 7.1?

670


How to do the error handling of if ur source is flatfiles?

1604


Describe an informatica powercenter?

714


Is stop and abort are same in informatica?

657


What is joiner transformation?

660


Explain the types of lookup transformation?

691


Is there any target staging area in informatica not staging area

2230


What are different types of transformations available in informatica?

670


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1618