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 / jayashree
Refer to Page 302 of Transformation Guide:
If a row meets more than one Group Filter Condition, then PC
Server passes this row multiple times.
Hence both the targets will be loaded
PC Server determines the order of evaluation for each
condition based on the order of connected output groups.
Hence first Target1 and then Target 2.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is informatica? Why do we need it?
What are the mapping parameters and mapping variables?
Where can we find the throughput option in informatica?
generate date / time dimension in informatica
What is a sorter transformation?
Which transformation should we use to normalise the COBOL and relational sources?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain the different lookup methods used in informatica?
Why do we need informatica?
design of staging area?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the Process to creating lookup transformation in informatica
How can we use batches?
Explain pushdown optimization and types in informatica
What are the differences between oltp and olap?