Saturday, August 11, 2012

Informatica Experienced Questions


  1. Difference between Informatica 7x and 8x?
  2. Difference between connected and unconnected lookup transformation in Informatica?
  3. Difference between stop and abort in Informatica?
  4. Difference between Static and Dynamic caches?
  5. What is Persistent Lookup cache? What is its significance?
  6. Difference between and reusable transformation and mapplet?
  7. How the Informatica server sorts the string values in Rank transformation?
  8. Is sorter an active or passive transformation? When do we consider it to be active and passive?
  9. Explain about Informatica server Architecture?
  10. In update strategy Relational table or flat file which gives us more performance? Why?
  11. What are the out put files that the Informatica server creates during running a session?
  12. Can you explain what are error tables in Informatica are and how we do error handling in Informatica?
  13. Difference between constraint base loading and target load plan?
  14. Difference between IIF and DECODE function?
  15. How to import oracle sequence into Informatica?
  16. What is parameter file?
  17. Difference between Normal load and Bulk load?
  18. How u will create header and footer in target using Informatica?
  19. What are the session parameters?
  20. Where does Informatica store rejected data? How do we view them?
  21. What is difference between partitioning of relational target and file targets?
  22. What are mapping parameters and variables in which situation we can use them?
  23. What do you mean by direct loading and Indirect loading in session properties?
  24. How do we implement recovery strategy while running concurrent batches?
  25. Explain the versioning concept in Informatica?
  26. 26.What is Data driven?
    27.What is batch? Explain the types of the batches?
    28.What are the types of meta data repository stores?
    29.Can you use the mapping parameters or variables created in one mapping into another mapping?
    30.Why did we use stored procedure in our ETL Application?
    31.When we can join tables at the Source qualifier itself, why do we go for joiner transformation?
    32.What is the default join operation performed by the look up transformation?
    33.What is hash table Informatica?
    34.In a joiner transformation, you should specify the table with lesser rows as the master table. Why?
    35.Difference between Cached lookup and Un-cached lookup?
    36.Explain what DTM does when you start a work flow?
    37.Explain what Load Manager does when you start a work flow?
    38.In a Sequential batch how do i stop one particular session from running?
    39.What are the types of the aggregations available in Informatica?
    40.How do I create Indexes after the load process is done?
    41.How do we improve the performance of the aggregator transformation?
    42.What are the different types of the caches available in Informatica? Explain in detail?
    43.What is polling?
    44.What are the limitations of the joiner transformation?
    45.What is Mapplet?
    46.What are active and passive transformations?
    47.What are the options in the target session of update strategy transformation?
    48.What is a code page? Explain the types of the code pages?
    49.What do you mean rank cache?
    50.How can you delete duplicate rows with out using Dynamic Lookup? Tell me any other ways using lookup delete the duplicate rows?


2 comments:

  1. could you please provide answers to the above interview questions to iyer6214@gmail.com

    ReplyDelete
  2. Could you provide answers to above questions.
    my mail Id : nikhilkumar443@gmail.com

    ReplyDelete

Thank you :
- kareem