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 degradation?

976

What is report as filter in microstrategy?

917

What is smart metric?

968

Does microstrategy intelligence server run on windows®, unix®, or linux®?

970

What is non-aggregate metric?

1016

What are the types of facts in microstrategy?

1032

What is the difference between absolute filtering and standard filtering in microstrategy?

979

What information is shared by the application across microstrategy web nodes?

1046

What is percent-to-total shortcut metric in microstrategy?

977

What are the different types of metrics available in microstrategy?

974

What are vldb properties in microstrategy?

1044

What is a compound attribute in microstrategy?

1037

What is the conflict resolution window?

1042

Can schema objects be copied across projects with microstrategy object manager?

980

How do we resolve attribute roles in microstrategy?

1151

Un-Answered Questions { Data Warehouse }

Mention few power centre client applications with their basic purpose?

951

How do dates work in sas?

1139

List out teradata data types?

1006

What are shortcuts? Where it can be used? What are the advantages?

1073

How many types of nodes supported by Redshift and what are the functions of nodes?

Can you define merge?

1123

What is the difference between the proc sql and data step?

1174

what is the difference b/w the refresh and buffered data?

2342

What is the difference between datastage and informatica?

1118

what is session partitioning?

1879

Tell me what is full load & incremental or refresh load?

950

How transaction file different from that of a sort file?

1416

What are the frequently used data types in teradata?

1083

Explain the use of aggregator cache file?

1254

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1405

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