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
To import the flat file definition into the designer where should the flat file be placed?
How to generate sequence numbers without using the sequence generator transformation?
What are active and passive transformations?
What is the difference between a connected look up and unconnected lookup?
In development project what is the process to follow for an etl developer from day1
Explain sessions and how many types of sessions are there?
Reusable transformation and shortcut differences
What are Dimensional table?
How do you update the records with or without using update strategy?
What is meant by a domain?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to elaborate powercenter integration service?
Clarify the aggregator change?
what is the -ve test case in your project.
Slowly changing dimensions, types and where will you use them