1. What exactly is an informatica transformation?
2. What is active and passive transformation?
3. What is connected and unconnected transformation?
4. Is there any difference between pre-post session commands and pre-post sql commands?
5. Can we write an UNIX command in informatica?
6. What is SCD? Describe type1 and type2 SCD?
7. What is Confirmed Dimension?
8. What is the relationship between a dimension and a fact table? is it many to many to one to many?
9. What is simple star and multi-star schema?
10. How to avoid duplicates in informatica? At least 3-4 ways.
11. Difference between star and snow flake schema?
12. Explain the use of surrogate key?
13. What are the transformations that you have not used?
14. Do you have a distinct option in sorter?
15. If the problem is during target loading what all you can do?
16. What is OCI?
I will keep updating more questions and the answers in few days....
Tuesday, June 24, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment