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 the benefits of using microstrategy intelligence server?

1094

What is embedded metric?

1057

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

967

What is adaptive metric?

1000

What is metadata in microstrategy?

1183

Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

994

What does microstrategy intelligence server allow users to do?

1037

What are pass-through functions and why they are so called? Give some examples.

1110

What is transformation metric in microstrategy?

1073

What is heterogeneous mapping?

1184

What is pass through metrics in microstrategy?

1060

How does microstrategy object manager determine if two projects are related?

1114

What is a implicit attribute in microstrategy?

1716

What is a conditional attribute in microstrategy?

1157

What is microstrategy?

1033

Un-Answered Questions { Data Warehouse }

What are the different methods ot loading a dimension table? A fact table etc?

1085

Write the program through which the records can be updated?

1055

Which are the statements whose placement in the data step is critical?

1315

Where the data cube technology is used?

1009

is cognos 7 is better than cognos 8

2213

How can you validate all mappings in the repository simultaneously?

1429

Explain do we need an etl tool?

1076

where we cannot use sorter Transformation. if we use then we will not get correct data?

2253

How would you join a node to the already existing domain?

1188

Can we access the compute node of Redshift directly ?

How can we check the version of Teradata that we are using currently?

1114

How do we load data into Redshift?

SCD2 will work on only dimension tables as well as fact Table?

1464

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1147

Can you define drill across?

1036

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