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 would you consider as your biggest achievement and why?

1014

How we drill up week to month?

1079

Explain which versions are used in the bo dashboard work?

1097

Difference between zabo and webi?

1113

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1187

What you mean by drill across?

1024

How can I test reports in cagonos?

962

What is difference between page break and section report?

1216

How can I schedule reports in cognos?

1010

How create measures and demensions?

1049

What is meant by alternate drill down with ex?

1092

What is main advantage datawarehousing over oracle?

1007

What is drill down and slicing and dicing whats the difference between them?

1074

What is meant by junk dimension?

1187

What is catalog and types of catalogs in cagonos and which is better?

1011

Un-Answered Questions { Data Warehouse }

how many users can open or connect to one of the tm1 web application concurrently?

------------ Diff b/w MemberCaption and MemberDescription?

2321

What is use Array size in datastage

1785

What is etl process. How many steps etl contains explain with example?

962

What is metadata in context of a datawarehouse?

1060

what are the concerns of OLTP and DSS systems?

2451

How can we run the graph? How can we schedule the graph in unix?

958

Describe primary index in teradata?

1003

Explain what are the basic needs to join two sources in a source qualifier?

1149

What are the steps involved in creating dimensional modeling process?

1024

explain in detail about type 3?

1021

When to use local filter and when to use global filter?

1002

Explain the difference between oltp and olap?

1129

When do we analyze the tables? How do we do it?

963

What are the functions involved in shared information architecture?

1075

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