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
How do you convert single row from source into three rows into target?
difference between repository database and repository service?
What are the informatica performance improvement tips
What are ETL Tools?
What are mapplets?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How can you validate all mappings in the repository simultaneously?
Why do we need informatica?
How to convert multiple rows to single row (multiple columns) in informatica
Explain the types of lookup transformation?
Explain lookup transformation is active in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain the scenario which compels informatica server to reject files?
server hot-ws270 is connect to Repository B. What does it mean?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica