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
- 18993 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / jani basha
both records are load into 1st target only.... because in
Router if 1st condition satisfies then it will not go to 2nd
condition....
| Is This Answer Correct ? | 2 Yes | 22 No |
Post New Answer View All Answers
What is a rank transform?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can informatica be used for an organization?
Difference between Data and Index Caches?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to extract sap data using informatica? What is abap? What are idocs?
What is the difference between stop and abort in informatica
What are multi-group transformations?
Explain the aggregator transformation?
What is target load order?
How to generate sequence numbers using expression transformation?
How to load data in informatica ?
What differs when we choose the sorted input for aggregator transformation?
whats the logic to load the lower level of granularity of data to fact table.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
