Informatica Interview Questions Collection 2

1/25/2010 No Comment

HP Informatica Interview Questions Collection.

  1. Explain what is the difference between PowerCenter and PowerMart in Informatica?
  2. What is the purpose of using UNIX commands in Informatica. Which UNIX commands are generally used with Informatica.Can you explain in brief.
  3. When should you create the dynamic data store? Do you require a DDS at all for this?
  4. Which SDLC suits best for the data warehousing project?
  5. Can a source qualifier be used to perform a outer join when joining 2 database?
  6. Explain what is the difference between static cache and dynamic cache? 
  7. Explain how can you complete unrecoverable sessions in Informatica? 
  8. How can you handle two sessions in Informatica?
  9. can you explain how the Informatica server increases the session performance through partitioning the source?
  10. How do we run a workflow without using GUI i.e, Worlflow Manager, Workflow Monitor and pmcmd?
  11. In what all transformations the mapplets cant be used in Informatica??
  12. What are mapping parameters and varibles in which situation we can use it
  13. What are the different types of Commit intervals available? 
  14. Can you tell me what are the tasks that Loadmanger process will do? 
  15. What does the first column of bad file (rejected rows) indicate? Explain in brief.
  16. What do you mean by Code Page Compatibility in Informatica? 
  17. What do you mean by key factor in BRD?
  18. What is Strategy Transformation in Informatica?
  19. What is the difference between Rank and Dense Rank?
  20. Can you tell me what is the Rankindex in Ranktransformation in Informatica?
  21. When the informatica server marks that a batch is failed? 
  22. Which tool you use to create and manage sessions and batches and to monitor and stop the informatica server? 
  23. Can any one explain real time complain mappings or complex transformations in Informatica.Specially in Sales Domain.
  24. Please describe the Advantages and Disadvantages of star & snowflake schema?
  25. Explain how can you create or import flat file definition in to the warehouse designer? 
  26. How do you identify existing rows of data in the target table using lookup transformation? 
  27. How the Informatica server sorts the string values in Ranktransformation? 
  28. How to use incremental aggregation in real time?
  29. In which circumstances that Informatica server creates Reject files?
  30. What do you mean by mapplets in Informatica? 
  31. What are the different types of locks available in Informatica? 
  32. Can you tell me what are the tasks that source qualifier performs? 
  33. What exactly is a shortcut and how do you use it?
  34. Explain why is Code Page used for in Informatica?
  35. What do you mean by Load Manager 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