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 4037

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

 1618

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 4161

what is parallel query?

 1615

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

 1 4659

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

EDS, IBM,

1 7633

what are different types of partitioning in oracle ?

 3 10332

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

 2 9757

what are different storage options supported by oracle ?

 1598

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

ABC,

1 12548

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 4505

Un-Answered Questions { Data Warehouse }

Which date function advances a date, time or datetime value by a given interval?

655

Differentiate between hash file and sequential file?

570

What are the partitioning techniques available in link partitioner?

1743

Define Data Warehousing?

732

Define update strategy?

625




There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1795

How do you use reject loader.

2052

Briefly describe lookup transformation?

591

What do you mean by xml cache?

526

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

538

What is an aggregator transformation?

605

Explain the teradata primary index mechanics in detail with a diagram.

557

how does sas handle missing values in formats? : Sas programming

570

Can you explain engine tier in information server?

642

What are the difference types of stages?

610

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