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 57093

What is Snow Flake Schema design in database?

3 7823

What is ETL process in Data warehousing?

3 16883

How can we do ETL process in SQL Server?

ETL,

1 6892

What is ?Data mining??

2 5340

Compare ?Data mining? and ?Data Warehousing??

5 10695

What is BCP?

1 6049

How can we import and export using BCP utility?

1 6219

What is Bulk Insert?

3 12201

What is DTS ?

1 5402

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

Deloitte, TCS,

2315

What is an OLTP (Online Transaction Processing) System?

4 8907

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

1 5018

What is Conceptual, Logical and Physical model?

1 12963

What is Data purging?

TCS,

8 52721

Un-Answered Questions { Data Warehouse }

What all are steps in up gradation of Informatica server?

992

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2198

What are the various indexes in teradata?

972

Sequence generator, when you move from develoment to production how will you reset

1943

What is difference between content store and content manager?

925

Explain the main difference between the sas procedures and functions? : Sas-administrator

1016

What do you mean by ttu in teradata?

974

I have a flat file, want to reverse the contents of the flat file

1068

What is the difference between olap and datawarehosue?

897

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

981

What is data stream and data adapter is it same are different?

926

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1096

How to Create a folder using pmrep command?

1107

what is the meaning of ending bulk load mode?

How do we convert from Numeric to be Words?

2942

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