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 fact extension?

1050

Explain the Roles in mstr?

939

How does microstrategy object manager integrate with the microstrategy product suite security model?

882

What is dynamic aggregation in microstrategy?

939

What is scanmd and md doctor?

1027

Can the administrator easily maintain and manage microstrategy intelligence server?

930

What is derived metric?

954

What is a security filter in microstrategy?

989

What are logical views used for in microstrategy?

906

What are public objects?

1013

What is the difference in the way microstrategy handles custom group and consolidations?

953

How conflicts occur and what are the ways to resolve them?

907

What are configuration objects?

1010

What are the enhanced features in teradata v2r5 and v2r6?

1105

Explain Teradata performance tuning and optimization?

1123

Un-Answered Questions { Data Warehouse }

What is a conditional attribute in microstrategy?

1055

What is difference between query studio and report studio?

1054

What is meta data and system catalog?

2263

What are the advantages of using sas?

1116

Define ds designer?

1236

What is an error log table in informatica occurs and how to maintain it in mapping?

929

Is possible to create skid in dim,fact tables?

2604

what is SDLC way of code development?

1995

define junk dimension?

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2308

How do you update the records with or without using update strategy?

1078

What is data cleaning? How can we do that?

1012

Enlist the advantages of informatica.

1020

How many types of sessions are there in informatica.please explain them?

1132

Can we collect statistics on multiple columns?

1021

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