Informatica FAQs, Interview Questions

3/09/2010 No Comment

Informatica FAQs, Interview Questions and Technical Interview Questions.

  1. Explain what do you mean by a source qualifier in Informatica? What is meant by Query Override?
  2. What do you mean by QTP in Data Warehousing?
  3. What is the difference between constrained base load ordering and target load plan
  4. Explain what is hierarchies in DWH?
  5. What do you mean by user defined Transformation?
  6. Why we use partitioning the session in Informatica? 
  7. Can you copy the session to a different folder or repository? 
  8. Explain how can we access MAINFRAME tables in INFORMATICA as a source ?
  9. How do we load data by using period dimension?
  10. Explain how is the union transformation active transformation?
  11. How to implement de-normalization concept in Informatica Mappings? 
  12. Using unconnected lookup, how we you remove nulls and duplicates? 
  13. What are the data movement modes in Informatica ? 
  14. What are the properties should be notified when we connect the flat file source definition to relational database target definition?
  15. Explain what are two types of processes that Informatica runs the session? 
  16. What do you mean by a surrogate key in Informatica ?
  17. Can you tell me what do you mean by a rank transformation?where can we use this transformation?
  18. What is the difference between constraints based load ordering and target load plan?
  19. What is the limit to the number of sources and targets you can have in a mapping
  20. Can you tell me what do you mean by version controlling? 
  21. Why we use stored procedure transformation in Informatica? 
  22. Explain how can we delete duplicate rows from flat files ?
  23. How can we load from PL/SQL script into Informatica mapping?
  24. How many Data marts are there in your project? 
  25. How can you import oracle sequence into Informatica?
  26. If you are workflow is running slow in Informatica. Where do you start trouble shooting and what are the steps you follow?
  27. What is a time dimension? Please provide an example.
  28. What do you mean by Dynamic Data Store. Explain? 
  29. Can you tell me what do you mean dynamic insert in Informatica?
  30. What do you mean by re-dimension in Informatica?
  31. Explain what is the difference between dynamic and static lookup?
  32. What do you mean by DTM session in Informatica?
Related Posts

No comments :


Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer