Data Warehouse Interview Questions
Questions Answers Views Company eMail

if you use oracle sql*loader , how do you transform data with it during loading?

1569

three ways sql*loader could load data, what are those three types?

1 4052

what are the others of "bad files" and "discard files" when using sql*loader?

1624

how do you use commit frequencies? how does it affect loading performance?

1 3856

what are the other factors of the database on which the loading performance depend?

1495

what is parallelism?

2 4170

what is parallel query?

1624

what are different ways of loading data to data warehouse using oracle?

1 4672

what is table partitioning? How it is useful to warehouse database?

EDS, IBM,

1 7640

what are different types of partitioning in oracle ?

3 10341

what is indexing ? what are different types of indexes supported by oracle ?

2 9771

what are different storage options supported by oracle ?

1606

what is query optimizer? what are different types of optimizer s supported by oracle ?

ABC,

1 12560

explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

IBM, Ness Technologies,

3 14900

Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.

iFlex, Wipro,

1 4521


Un-Answered Questions { Data Warehouse }

What are the advantages of cold fusion?

528


Explain the code page compatibility?

639


Tell me more about the parameters in macro? : sas-macro

584


What are the steps of implementing data warehousing?

531


What is the difference between informatica and datastage?

652






Is the value of staging variable stored temporarily or permanently?

573


What system options would you use to help debug a macro? : sas-macro

636


What are the other names given to data warehousing?

640


What is drilling across?

557


Explain ddl (data definition language)?

575


What is workflow manager?

571


Why is sorter an active transformation?

661


Can Bo generates the Report from the cubical data Explain?

1626


What are the various kinds of containers available in datastage?

561


Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1474