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?
- 9 Answers
- 19636 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Enlist few areas or real-time situations where informatica is required.
What will be the approach?
Explain direct and indirect flat file loading (source file type) - informatica
Different circumstance which drives informatica server to expel records?
What is the benefit of partitioning a session?
What are roles and groups and benefits of using them?
How to load last n records of file into target table - informatica
How many types of sessions are there in informatica.please explain them?
Briefly define reusable transformation?
How to implement security measures using repository manager?
How to differentiate between the active and passive transformations?
Explain informatica architecture - version 8 / 9
What is the difference between router and filter?
how many types of dimensions are available in informatica?
what are 3 tech challenges/ common issues you face?
