Answer Posted / ravindra.15aug
Normally four joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join
| Is This Answer Correct ? | 38 Yes | 2 No |
Post New Answer View All Answers
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
Slowly changing dimensions, types and where will you use them
What is the need of etl tools?
In warehouses how many schemas are there?
What are the different versions of informatica?
What is workflow manager?
How to load the data from people soft hrm to people soft erm using informatica?
Explain scd type 3 through mapping.
wf dont have integration severances how you can run?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
tell me the rules and responsblites in our project(my project is development)
What is blocking transformation?
What is decode in static cache?
Enlist few areas or real-time situations where informatica is required.
What happens when a session fails and you click on recover?