Interview questions

Database Administrator (dba) interview questions – page 13

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

  1. In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

  2. What are the scheduling options to run a sesion?

  3. What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow monitor? . The system hangs when 'Online' server connect option. The Informatica is installed on a Personal laptop.

  4. What is a collection?

  5. What are the types of groups in Router transformation?

  6. What is IQD file?

  7. What is difference b/w Informatica 7.1 and Abinitio

  8. What is pushdown optimizations in pc 8.x with example?

  9. What is Micro Strategy? Why is it used for? Can any one explain in detail about it?

  10. What happens if you try to create a shortcut to a non-shared folder?

  11. How can you stop a batch?

  12. How to load the data from people soft hrm to people soft erm using informatica?

  14. How do you handle decimal places while importing a flatfile into informatica?

  15. Can we run a group of sessions without using workflow manager

  16. How the informatica server sorts the string values in Ranktransformation?

  17. Can you use the maping parameters or variables created in one maping into any other reusable transformation?

  18. Why use the lookup transformation?

  19. How to find second maximum value from a table?

  20. 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?

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

  22. What is the exact meaning of domain?

  23. How to export mappings to the production environment?

  24. What is CHECK PENDING ?

  25. What is the hierarchies in DWH

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

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

  29. Can you copy the batches?

  30. 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

  31. What is a join? Explain the different types of joins?

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

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