Interview questions

Database Administrator (dba) interview questions – page 14

1,040 questions. Tap “Show answer” to check yourself.

  1. What are Target Types on the Server?

  2. Can Informatica load heterogeneous targets from heterogeneous sources?

  3. How to recover sessions in concurrent batches?

  4. What are Dimensions and various types of Dimensions?

  5. What is Code Page used for?

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

  7. What is a composite index and how does it differ from a multiple index?

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

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

  10. What transformation you can use inplace of lookup?

  11. What is the status code?

  12. Why you use repository connectivity?

  14. What is data merging, data cleansing, sampling?

  15. If you have four lookup tables in the workflow. How do you troubleshoot to improve performance?

  16. What are various types of Aggregation?

  17. What is Partitioning ? where we can use Partition? wht is advantages? Is it nessisary?

  18. When we create a target as flat file and source as oracle.. how can i specify first rows as column names in flat files...

  19. How can i transform row to column?

  20. Can i use a session Bulk loading option that time can i make a recovery to the session?

  21. Can i run the mapping with out starting the informatica server?

  22. How can you access the remote source into your session?

  23. In a scenario I want to change the dimensions of a table and normalize the renormalized table which transformation can I use?

  24. If the workflow has 5 session and running sequentially and 3rd session hasbeen failed how can we run again from only 3rd to 5th session?

  25. How to get two targets T1 containing distinct values and T2 containing duplicate values from one source S1.

  27. What is the basic structure of PL/SQL ?

  28. To achieve the session partition what are the necessary tasks you have to do?

  29. Why is meant by direct and indirect loading options in sessions?

  30. SCD Mappings are mostly used Unconnected Lookup Transformation. Unconnected Lookup used static Cache only.At this time how can you insert or update date in Target by using static cache?

  31. What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA

  32. What are mapping parameters and varibles in which situation we can use it

Companies that ask Database Administrator (dba) questions

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