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
permutations of mapplet
How to generate sequence numbers without using the sequence generator transformation?
How to call shell scripts from informatica?
Target increases every day even though no new record was inserted
What is the commit type if you have a transaction control transformation in the mapping?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to extract the informatica rejected data?
How many input parameters can exist in an unconnected lookup?
How to implement security measures using repository manager?
scenario where i can use only concurrent execution of workflow.
Can you generate sequence numbers without using the sequence generator transformation?
Enlist the differences between database and data warehouse.
define galaxy repository in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the basic requirements to join two sources in a source qualifier transformation using default join?