Interview questions

Database Administrator (dba) interview questions – page 19

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

  1. What are the data movement modes in informatcia?

  2. What are the settiings that you use to cofigure the joiner transformation?

  3. What is Datadriven?

  4. What is the difference between Informatica 7.0 and 8.0 ?

  5. Define Informatica Repository?

  6. What is a view? How it is related to data independence? And what are the different types of views,and what is Materialize view

  7. How do you create a mapping using multiple lookup transformation?

  8. What is polling?

  9. What is the mapping for unit testing in Informatica, are there any other testings in Informatica, and how we will do them as a etl developer. how do the testing people will do testing are there any specific tools for testing

  10. What is lookup transformation and update strategy transformation and explain with an example.Thanks in Advance

  11. What are the properties should be notified when we connect the flat file source definition torelational database target definition?

  12. If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

  14. What is Router transformation?

  15. Can you start a batches with in a batch?

  16. When will data in the data base is updated

  17. Difference between static cache and dynamic cache?

  18. What is meant by complex mapping

  19. What is the diferrence between slice and dice & drill through

  20. What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples?

  21. Define the Non-Voice Accounting Process and Semi-Voice Non-accounting process in BPO?

  22. Which procedure should be called to enable a DFF in a form?

  23. How do I control what happens when I start Word?

  24. How do I change the format of the number symbols in a numbered list without changing the rest of the text?

  25. Can you add the Cascading promprts in Business Objects? (Based on Country prompt selection you need to provide the option to select Sate/Province in the next State prompt. That means dynamically refresh the data load in the state list values)

  27. Atleast how many set of data must a data model have before a data model can be base on it?

  28. How to parametarise a field in a sequential file?I am using Datastage as ETL Tool,Sequential file as source.

  29. What's universal join in BOs?

  30. What is Data warehosuing Hierarchy?

  31. Where we use link partitioner in data stage job?explain with example?

  32. How to kill the job in data stage?

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