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

Explain a linked cube?

960

Explain what are the methodologies of data warehousing?

926

Where we use surrogate key explain with example?

1135

Explain difference between snow flake and star schema.

1054

Difference between e-r modeling and dimentional modeling?

937

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1029

Explain what are the different types of data warehousing?

963

Explain what are the advantages data mining over traditional approaches?

1163

Explain er diagram?

999

Explain what are the vaious etl tools in the market?

944

Explain what are the steps to build the data warehouse?

953

What are the data marts?

981

Explain conformed fact?

975

Explain the difference between view and materialized view?

948

What are the vaious etl tools in the market?

1 2442

Un-Answered Questions { Data Warehouse }

How to clean the datastage repository?

1127

What are the functions involved in shared information architecture?

1073

Explain attribute role?

1091

What are the default statistics for means procedure?

1246

What are the steps to create a data model?

1056

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

2023

what type of raid setup would you put your tx logs?

951

How would you define the end of a macro?

1097

Under which circumstances, informatica server creates reject files?

1098

How do we drill through from a powerplay cube to reportnet?\

2354

Explain different types of partitioning?

1043

what is slowly changing dimension? : Sas-di

1128

Where $mpjret is used in ab-initio?

1147

Can u access a repository created in previous version of Informatica?

1860

What is teradata? Also, list out some of the primary characteristics of teradata.

1060

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