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 cubes and olap cubes?

985

What are the three tiers in etl?

1113

What are dimensions?

1060

What are the steps involved in etl process?

1026

What is initial load and what is full load?

987

Explain different types of partitioning?

1042

List few etl bugs?

944

What are three tier systems in etl?

1066

What are your responsibilities as an etl tester?

1160

What is grain of fact?

978

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

999

What do you understand by the term ‘transformation’?

1038

Explain the key challenges that you face while performing etl testing.

1009

Mention few test cases and explain them?

927

Explain etl mapping sheets?

1077

Un-Answered Questions { Data Warehouse }

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1881

What are the various tools used in etl?

1045

What is the sequence generator transformation in informatica?

1184

Explain what is the extension of file to save template?

977

how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

872

What is sq transformation?

1163

can u give example for factless fact table

6649

Explain etl?

980

What is fact extension?

1123

What is the difference between check point and phase?

1309

What is meant by LDAP users?

1209

What are the data types in sas?

1062

What is repository manager?

989

What is domain in terms of informatica?

1007

Do we need an ETL tool? When do we go for the tools in the market?

961

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