Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 8736

what is main functional differences between BO and COGNOs?

TCS,

5 12623

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

iGate,

6 11228




SAS System ?

5 7946

sas macros

TCS,

12 18203

how to test reports in businessobjects?

TCS,

8 47694

What is source qualifier?

2 6642

Difference between DSS & OLTP?

IBM,

6 39932

Explain grouped cross tab?

1660

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14918

How many repositories can we create in Informatica?

Informatica,

14 18301

What is surrogate key?

IBM, Informatica,

5 17168

What is difference between Mapplet and reusable transformation?

UST,

3 3616

What is aggregate awareness?

2 5256

Explain reference cursor?

1204







Un-Answered Questions { Data Warehouse }

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

56


Explain the Roles in mstr?

59


Can you explain engine tier in information server?

68


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

1483


What are loops in Datawarehousing?

71






What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

47


What is bteq utility in teradata?

52


What is informatica?

58


What is etl process?

55


What is teradata and why it is used?

52


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

60


What are the different versions of sas that you have used until now? : sas-grid-administration

45


What information does a .dbc file extension provides to connect to the database?

57


We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

57


How do you promote a non-reusable transformation to reusable transformation?

81