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

Can you explain the advantage of using shortcuts?

990

Can you define snapshot?

883

Can you define a catalog and types of catalogs in cognos?

1004

Can you define report item?

996

Can you define drill down and drill up?

1002

Can you explain dynamic query mode?

1005

Can you define materialized view?

995

Can you define confirmed dimension?

1030

Can you define cognos decision stream?

955

What are the different type of securities can we apply in framework manager?

1 1400

What is looping and how to avoid it in framework manager?

1166

Can you define pivot?

1022

Can you explain new content durability?

980

What are the steps to import the two data sources in framework manager?

995

Can you define folder?

921

Un-Answered Questions { Data Warehouse }

What is metadata in context of a datawarehouse?

985

What is the syntax for case when statement?

1074

Why filter transformation is an active one?

941

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

902

What is a data warehousing?

1080

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

998

What are the different options available for update strategy?

953

Differentiate between odbc and drs stage?

1007

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1123

Why might the optimizer use a table scan when an index is available?

2266

dumps needed ASAP for - C2020-180 Cognos IBM Certification

2170

what is ds administrator used for?

1123

how would u estimate the size of Aggregator transform data and index cache?

2385

Name few SAS functions?

1048

What are the design features involved in teradata?

993

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