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 / moorthy g

Both Condition Are Satisfied,
So, It will load two targets. (T1 And T2)

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

743


How to elaborate powercenter integration service?

640


Explain where to store informatica rejected data? How to extract the informatica rejected data?

567


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

542


What is substr in informatica?

656






How to create or import flat file definition in to the warehouse designer?

600


What are the features of complex mapping?

632


What is joiner change?

662


What are ETL Tools?

653


How can a transformation be made reusable?

655


How you know when to use a static cache and dynamic cache in lookup transformation?

1328


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1749


Define the various join types of joiner transformation?

552


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1578


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1672