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
Is it possible to create multiple domains on a single Informatica server?
How to elaborate powercenter integration service?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
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?
What is substr in informatica?
How to create or import flat file definition in to the warehouse designer?
What are the features of complex mapping?
What is joiner change?
What are ETL Tools?
How can a transformation be made reusable?
How you know when to use a static cache and dynamic cache in lookup transformation?
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.
Define the various join types of joiner transformation?
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
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