Just Crack Interview

Data Warehouse Developer interview questions – page 17

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

Advertisement

  1. Concurrent prg

  2. How open document syntax works?

  3. Can you tell me where the applications where ware house management system is used?

  4. What is mean by aggregate aware?How we are using this function?

  5. There are 1000 source tables containing the same data with different file formats,now i want to load into a single target table ..how to achieve ?

  6. Why we have to maintain the file names in Capital Letter?( Library/FMB)

  7. Disadvantage in File Processing System?

  8. How do you find out the FMB file name?

  9. What is fact less fact table? where you have used it in your project?

  10. What is the procedure to load the fact table.Give in detail?

  11. What are the reusable transforamtions?

  12. What is a junk dimension

  13. Advertisement

  14. What is the look up transformation?

  15. What are the uses of key value locking in Informix?

  16. In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

  17. What r the unsupported repository objects for a mapplet?

  18. The differences between using native and ODBC server-side databaseConnections

  19. What is explain in teradata?

  20. What is aggregate table and aggregate fact table ... any examples of both

  21. What is a reference trigger? Can we modify a reference trigger?

  22. Which two can be implemented as a centrally located logical architecture?a)operational data storeb)logical data mart

  23. How to Import universes and user from business object 6.5 to XI R2, it is showing as some ODBC error is there any setting to change?

  24. Can any one comment onsignificance of oracle 9i in informatica when compared to oracle 8 or 8i.I mean how is oracle 9i advantageous when compared to oracle 8 or 8i when used in informatica

  25. Can U use the maping parameters or variables created in one maping into another maping?

  26. Advertisement

  27. What is the Router transformation?

  28. I have use three select statement in inside prcedure body both three select statment given no_data_found exception but i handled only one exception in exception section but i want to know which select statment given no_data_found?

  29. Where do we use MQ series source qualifier, application multi group source qualifier. just give an example for a better understanding

  30. What is index awareness in universe?

  31. What are variable ports and list two situations when they can be used?

  32. If one wants to see the time dependent master data, what table is to be referred?

Advertisement
Advertisement