Interview questions

Database Administrator (dba) interview questions – page 18

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

  1. On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

  2. What is the target load order?

  3. Can u tell me how to go for SCD's and its types.Where do we use them mostly

  4. What are partition points?

  5. How can u work with remote database in informatica?did u work directly by using remoteconnections?

  6. What are the measure objects

  7. What is the default join that source qualifier provides?

  8. What is a command that used to run a batch?

  9. Can you use the maping parameters or variables created in one maping into another maping?

  10. How can you improve the performance of Aggregate transformation?

  11. In realtime which one is better star schema or snowflake star schemathe surrogate will be linked to which columns in the dimension table.

  12. What is the need and when do we use a dynamic lookup cache?

  14. How many types of facts and what are they?

  15. What are the joiner caches?

  16. What is incremantal aggregation?

  17. Can any one tell me how to run scd1 bec it create two target tables in mapping window and there are only one table in warehouse designer(means target).. so if we create one new table in target it gives error..

  18. 1.can u explain one critical mapping?2.performance issue which one is better? whether connected lookup tranformation or unconnected one?

  19. What is Session and Batches?

  20. What is the diff b/w Stored Proc (DB level) & Stored proc trans (INFORMATICA level) ?again why should we use SP trans ?

  21. Can batches be copied/stopped from server manager?

  22. Where should you place the flat file to import the flat file defintion to the designer?

  23. How do you configure mapping in informatica

  24. When do u use a unconnected lookup and connected lookup...what is the difference between dynamic and static lookup...y and when do v use these types of lookups ( ie...dynamic and static )

  25. I have windows xp. I was told a person could find out what sites a person is looking on your computer. How do you do this. I have a person who uses my computer, and I think he is looking at sites he should not be viewing.

  27. Know the rules associated with transferring and sharing objects between folders.

  28. What is update strategy transformation?

  29. When can an insert of a new primary key value threaten referential integrity?

  30. Explain use of update strategy transformation

  31. What are the tasks that source qualifier performs?

  32. Diff between static and dynamic cache? and please explain with one example?

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