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?

973

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?

1020

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 }

i have one file i saved in csv how can i take these file into framework manager

2082

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2370

What is the difference between datawarehousing and businessintelligence?

1100

If your client wanted to customize the null value, how would you do that?

994

State the difference between an operational datastage and a data warehouse?

1131

What is workflow manager?

1047

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1012

Explain meta data?

1032

Define enterprise data warehousing?

1204

What are the uses of sas?

1273

As union transformation gives UNION ALL output, how you will get the UNION output?

1108

What are the components of ascential data stage?

1189

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2263

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1077

How would you invoke a macro? : sas-macro

1122

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