1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

 1565

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

 1 4043

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

 1620

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

 1 3848

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

 1489

what is parallelism?

 2 4164

what is parallel query?

 1616

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

 1 4661

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

EDS, IBM,

1 7636

what are different types of partitioning in oracle ?

 3 10336

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

 2 9757

what are different storage options supported by oracle ?

 1600

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

ABC,

1 12551

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

IBM, Ness Technologies,

3 14884

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 4508

Un-Answered Questions { Data Warehouse }

What is package in BO

2674

What are the reasons for which business can trust the approach of data processing?

610

Compare and contrast aggregates & indexes

3335

Explain me ETL project architecture in Detail?

1916

What are the types of caches in lookup?

560




One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1743

What are the main differences you have observed between 7.x and 8.x version of datastage?

614

How do you add default rules in the transformer?

642

How do we load data into Redshift?

5

What is a dw? Why do we need it?

531

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

686

What are data-driven sessions?

708

Explain heterogeneous mapping?

539

Explain the shared cache and re-cache?

602

Explain static reports?

535

For More Un-Answered { Data Warehouse } Questions Click Here