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?

1123

Explain the Roles in mstr?

978

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

938

What is dynamic aggregation in microstrategy?

974

What is scanmd and md doctor?

1067

Can the administrator easily maintain and manage microstrategy intelligence server?

1000

What is derived metric?

989

What is a security filter in microstrategy?

1021

What are logical views used for in microstrategy?

965

What are public objects?

1054

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

995

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

948

What are configuration objects?

1056

What are the enhanced features in teradata v2r5 and v2r6?

1138

Explain Teradata performance tuning and optimization?

1164

Un-Answered Questions { Data Warehouse }

Define bulk load mode?

In BTEQ, how are the session-mode parameters being set?

1143

what is study design in while working with SAS? what are screening variables in SAS?

2242

Which lifecycle we will use for reporting?

974

Copy ".roi" file of management console to another path of management console's folder using ".rox" file. or any command of actuate. Is it Possible? if Yes then pls give me Example.

2924

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

965

Difference between inner join and outer join?

1026

What is node? How many nodes and amps used in your previous project?

1110

what has been your most common programming mistake? : Sas programming

1108

Explain about ab initio’s dependency analysis?

1168

how do you manage the production space. what are the proactive methods you can take ?

1945

Can we create universe with no cache??

2508

Write the different tools in the workflow manager?

1066

How to generate or load values in to the target table based on a column value using informatica etl tool.

1074

define under feeding?

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