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 / 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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain the shared cache and re-cache?
Clarify the aggregator change?
What are the different components of powercenter?
Where is metadata stored?
In how many ways we can create ports?
Is there any target staging area in informatica not staging area
Can informatica load heterogeneous targets from heterogeneous sources?
what are the deliverables?in your project?
What all are steps in up gradation of Informatica server?
What can we do to improve the performance of informatica aggregator transformation?
What is persistent lookup cache?
Performance tuning in UNIX for informatica mappings?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use