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 is difference between user and database in teradata?

1073

What is the difference between fastload and multiload?

1385

What is real time and near real time data warehousing?

1118

What is dimensional modeling?

1087

What are the multiload utility limitations?

1063

What is a sparse index?

1087

Can we collect statistics on table level?

1037

What interface is used to connect to windows based applications?

1115

What is primary index and secondary index?

1028

How many bi services node can be clustered together?

875

What is level based metrics.how will you create it?

877

How to get sql from obiee for reports?

887

Have you created hierarchy in obiee. If so where and how?

892

How will you do different types of narrative reports in obiee?

901

How the users created differs from rpd/answers/dashboards level?

816

Un-Answered Questions { Data Warehouse }

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

959

what is star schema? : Sas-di

1130

What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

949

What is a Query Subject?

1095

How to add default rules in the transformer?

1234

Explain difference between zabo and webi?

1102

What you mean by drill across?

1021

What are the different types of parallelism in ab initio?

1222

What is de-partition in abinitio?

1364

What are components of report studio?

1057

What is the order of application for output data set options, input data set options and SAS statements?

1561

-------------How you design DWH?

2316

What is authentication? How many types of authentication.

916

What is the meaning of decode in informatica?

1122

what are the session parameters? How do u set them?

2050

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