Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What are Fact tables and Dimension Tables?

IBM,

6 57085

What is Snow Flake Schema design in database?

3 7818

What is ETL process in Data warehousing?

3 16879

How can we do ETL process in SQL Server?

ETL,

1 6887

What is ?Data mining??

2 5334

Compare ?Data mining? and ?Data Warehousing??

5 10685

What is BCP?

1 6047

How can we import and export using BCP utility?

1 6211

What is Bulk Insert?

3 12194

What is DTS ?

1 5400

Can you brief about the Data warehouse project you worked on?

Deloitte, TCS,

2314

What is an OLTP (Online Transaction Processing) System?

4 8900

What is an OLAP (On-line Analytical processing) system?

1 5015

What is Conceptual, Logical and Physical model?

1 12959

What is Data purging?

TCS,

8 52703

Un-Answered Questions { Data Warehouse }

What is the use of powerplay web viewer in cognos?

1028

How we can scale Reshift database?

Explain dimensional modelling?

916

what is the difference steps for data modeling?

2047

What is the primary index in teradata?

1112

Code the tables statement to produce a multi-level frequency?

937

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1985

How transaction file different from that of a sort file?

1353

What are the different plug-ins stages used in your projects?

1026

Can you explain a cognos controller?

962

What are the different types of datawarehosuing?

944

What are the advantages of using cognos sql?

1123

What are the primary usages of datastage tool?

1016

AE datasets names? how many types?

2444

What is the difference between a data mart and a data warehouse?

993

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