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
What is the difference between informatics 7x and 8x and what is latest version?
What are the main issues while working with flat files as source and as targets ?
If informatica has its scheduler why using third party scheduler?
What is a surrogate key?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the difference between a repository server and a powerhouse?
Where are the source flat files kept before running the session?
Do you find any difficulty while working with flat files as source and target?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the informatica performance improvement tips
Partition, what happens if the specified key range is shorter and longer
how to load dimension table and fact table. plz tell me the steps.
expain about the tune parameters?