Interview questions

Informatica interview questions – page 8

484 questions. Tap “Show answer” to check yourself.

  1. Why use the lookup transformation?

  2. I have an requirement where in the columns names in a table (Table A) should appear in rows of target table (Table B) i.e. converting columns to rows. Is it possible through Informatica? If so, how?

  3. What are the different types of transformation available in informatica. and what are the mostly used ones among them

  4. What is the exact meaning of domain?

  5. How to export mappings to the production environment?

  6. What is the hierarchies in DWH

  7. How do I import VSAM files from source to target. Do I need a special plugin

  8. What r the connected or unconnected transforamations?

  9. What are the out put files that the informatica server creates during the session running?

  10. Can you copy the batches?

  11. How to append the records in flat file(Informatica) ? Where as in Datastage we have the options i) overwrite the existing fileii) Append existing file

  12. To provide support for Mainframes source data,which files r used as a source definitions?

  14. In which circumstances that informatica server creates Reject files?

  15. How does the server recognise the source and target databases?

  16. What are Target Types on the Server?

  17. Can Informatica load heterogeneous targets from heterogeneous sources?

  18. How to recover sessions in concurrent batches?

  19. What r the tasks that source qualifier performs?

  20. Can any body write a session parameter file which will change the source and targets for every session. i.e different source and targets for each session run.

  21. How do you decide whether you need ti do aggregations at database level or at Informatica level?

  22. What are Dimensions and various types of Dimensions?

  23. What is Code Page used for?

  24. Can you copy the session to a different folder or repository?

  25. When the informatica server marks that a batch is failed?

  27. How do we analyse the data at database level?

  28. What transformation you can use inplace of lookup?

  29. What is the status code?

  30. What are the common problems developers face while ETL development

  31. Why you use repository connectivity?

  32. What is parameter file?

Companies that ask Informatica questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide