Data Warehouse Developer interview questions – page 19

What are the various modules in Business Objects product?

Why an infocube has maximum of 16 dimensions?

What is the use of transactional triggers?

What is a Universe?

How is the data structure of System R different from the relational structure?

What you mean by Drill across and what is the difference between drill through,drill across?

What is Data Independence?

What are modal windows?

How teradata makes sure that there are no duplicate rows being inserted when its a SET table?

What is who column and how you set the values?

Where the procedures are stored in database?

Suppose you run a report with empty data , how will you inform the end user that it has no data ,while running the report in report studio?is it possible , if so how?

What the default privileges which get assigned ?

What is a Relation Schema and a Relation?

How do we Tune the BO Reports for Performance Improvement?

How do you display console on a window ?

What is hierarchy relationship in a dimension.whether it is:1. 1:12. 1:m3. m:m

What is table handler package?

What are difference between post database commit and post-form commit?

What is Object Oriented model?

What are the different modals of windows?

What is trigger associated with the timer?

What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP ?

What are the standard libraries available in template form?

1* what is the diffrance betwin DNS DHCP ? file system of windows? compare with nis & dns

What is the difference between enterprise data warehouse and data warehouse?

What is degree of a Relation?

What is the remove on exit property?

Which form objects we should not use?

What about DML changes dynamically?