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 57373

What is Snow Flake Schema design in database?

3 8016

What is ETL process in Data warehousing?

3 17069

How can we do ETL process in SQL Server?

ETL,

1 7011

What is ?Data mining??

2 5470

Compare ?Data mining? and ?Data Warehousing??

5 10918

What is BCP?

1 6156

How can we import and export using BCP utility?

1 6320

What is Bulk Insert?

3 12371

What is DTS ?

1 5496

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

Deloitte, TCS,

2378

What is an OLTP (Online Transaction Processing) System?

4 9157

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

1 5104

What is Conceptual, Logical and Physical model?

1 13085

What is Data purging?

TCS,

8 53061

Un-Answered Questions { Data Warehouse }

How do dates work in sas?

1139

Explain sessions and how many types of sessions are there?

1009

what is the basic structure sas administrator? : Sas-administrator

1005

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3756

How to add a number to a macro variable?

992

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

1080

Can decision tree be implemented using SQL?

2125

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

951

What is a conditional attribute in microstrategy?

1100

What does reusable transformation mean?

1132

define the logic behind the sparsity in cubes?

Explain the different lookup methods used in informatica?

1042

What leads to a cross-join or how does a cross-join occur?

950

What is difference between informatica power mart and power center?

1004

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1100

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