Just Crack Interview

Data Warehouse Developer interview questions – page 15

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

Advertisement

  1. What is custom development ?

  2. What is meant by alternate drill down with ex?

  3. Can u start a batches with in a batch?

  4. The designer includes a "Find" search tool as part of the standard tool bar. What can it be used to find?

  5. Is there any other repository domains rather than universe,security,doccument?

  6. In one of the Standard Oracle Form(Quoting Form), the Export (File -> Export) functionality is disabled. How can I enable this Export Functionality?

  7. What r the options in the target session of update strategy transsformatioin?

  8. How to read rejected data or bad data from bad file and reload it to target?

  9. Shall we delete exiting triggers?

  10. Which Flexfields you have customized,

  11. Do you know what is APPLYSYS in Oracle application database schema, what is APPS

  12. Whats the diff between Informatica powercenter server, repositoryserver and repository?

  13. Advertisement

  14. What is the use of ASSIGN statement in progress database?

  15. A)Which two statements are true about a foreign key?b)Is each Foreign Key must exist as a Primary Key?Foreign Keys can change values over time.

  16. What is the limit to the number of sources and targets you can have in a mapping

  17. Partitioning, Bitmap Indexing (when to use), how will the bitmap indexing will effect the performance

  18. Mention the database server operating modes available for Informix?

  19. What r the mapping paramaters and maping variables?

  20. How do you transfert the data from data warehouse to flatfile?

  21. What is profile

  22. What is command for supporting foreign key in Firebird?

  23. 1.what is difference between PAGE BREAK and Section Report?2.what is Main Advantage Datawarehousing over Oracle?

  24. What is transformer?Can anybody explain it.

  25. What three things do you consider to be the most important factors for a manager?

  26. Advertisement

  27. Difference between Rank and Dense Rank?

  28. What is auto invioce in OM module?what is use of it?

  29. What are the mapping paramaters and maping variables?

  30. How can we join 3 database like Flat File, Oracle, Db2 in Informatrica..

  31. What is function overloading?an example of function overloading in oracle?

  32. What is change data capture?

Advertisement
Advertisement