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 57606

What is Snow Flake Schema design in database?

3 8148

What is ETL process in Data warehousing?

3 17188

How can we do ETL process in SQL Server?

ETL,

1 7100

What is ?Data mining??

2 5565

Compare ?Data mining? and ?Data Warehousing??

5 11129

What is BCP?

1 6228

How can we import and export using BCP utility?

1 6422

What is Bulk Insert?

3 12496

What is DTS ?

1 5584

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

Deloitte, TCS,

2443

What is an OLTP (Online Transaction Processing) System?

4 9338

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

1 5179

What is Conceptual, Logical and Physical model?

1 13215

What is Data purging?

TCS,

8 53387

Un-Answered Questions { Data Warehouse }

differences between service based and product based?

2060

How can you export a component’s internal parameters ?

2456

what is session partitioning?

2209

why is sas considered self-documenting? : Sas programming

1192

what kind of system requirement is needed to run tm1 for a small installation?

What is tracing level and what are the types?

1017

Explain where do we use semi and non additive facts?

1070

Explain security filter?

1125

How does the internal authentication work in sas? : sas-grid-administration

1176

what is the hint? how to use it to reduce the query processing in program?

7986

What are templates in which way it is help full?

1056

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1313

Which means the first record should come as last record and last record should come as first record and load into the target file?

1144

What is Indexing? how did u implement indexing?

2572

What is meta data and system catalog?

2347

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