Just Crack Interview

Data Warehouse Developer interview questions – page 13

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

Advertisement

  1. What r the types of maping wizards that r to be provided in Informatica?

  2. What r the types of groups in Router transformation?

  3. Can u generate reports in Informatcia?

  4. What is a source qualifier?-

  5. Can we lookup a table from a source qualifer transformation-unconnected lookup

  6. What r the reusable transforamtions?

  7. What are the unsupported repository objects for a mapplet?

  8. Why dimenstion tables are denormalized in nature ?

  9. Define maping and sessions?

  10. How to use the unconnected lookup i.e., from where the input has to be taken and the output is linked?What condition is to be given?

  11. Identifying bottlenecks in various components of Informatica and resolving them.

  12. What r the types of maping in Getting Started Wizard?

  13. Advertisement

  14. How to get the first 100 rows from the flat file into the target?

  15. What r the types of metadata that stores in repository?

  16. What r the basic needs to join two sources in a source qualifier?

  17. How can we store previous session logs

  18. What are the major differences between Informatica 7.1,8.1,8.5 and 8.6?

  19. If the application is running very slow? At what points you need to go about the database in order to improve the performance?

  20. What is folder form?

  21. What is Data cleansing..?

  22. Can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

  23. Diffrence between ZABO and webi

  24. How to delete duplicate rows in flat files source is any option in informatica

  25. What all will be exported to the repository, when we export a universe ?

  26. Advertisement

  27. State the difference between Webi and Infoview

  28. Are Data mart and DWH normalised or denormalised ? Do both of them exist inthe same tier ?

  29. What is Form sub function?

  30. What is serialization?What is the difference between sql and oracle?

  31. How many error tables are there in fload and what are their significance/use?Can we see the data of error tables?How many error tables are their in mload and what is there use?When mload job fails, can we access mload tables? If yes then how?

  32. What is difference between partioning of relatonal target and partitioning of file targets?

Advertisement
Advertisement