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 / sruthi
both targets get loaded.the first target gets loaded first and then the second.it cheks both the conditions,as both cannot be loaded in the same target,it loads the data even in the second target.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
What could be the possible resons of locks by user?
generate date / time dimension in informatica
Define the various join types of joiner transformation?
What is session task and command task?
scenario where i can use only concurrent execution of workflow.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the use of code page?
complex mapping ur project u r invlve can u explain and give real time example give me ?
where to store informatica rejected data? How to extract the informatica rejected data?
Differentiate between a repository server and a powerhouse?
Name the different lookup cache(s)?
What is the fact table?
Can u generate reports in Informatica?
How do you use reject loader.