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

Explain the definition of normalized and denormalized view and what are the differences between them?

930

Explain the definition of normalized and denormalized view?

903

Explain why fact table is in normal form?

972

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

996

Explain dimensional modelling?

985

What is batch processing?

1036

What is aggregate fact table?

995

Suggest a good author for hyperion in data warehousing?

976

What is metadata in context of a datawarehouse and how it is important?

1051

What is metadata in context of a datawarehouse?

1060

What is data warehosuing hierarchy?

1175

Explain the data types present in bo n wht happens if we implement view in the designer n report?

981

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

971

Explain degenerate dimension table?

1052

Explain the data type of the surrogate key?

952

Un-Answered Questions { Data Warehouse }

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2894

Can we create a node as a gateway node and the same node can be assigned to a grid?

1083

What is the purpose of having stored procedures in a data-based?

1104

What is Bitmap Index?

1052

What is the use of stored procedures in teradata?

1008

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

4007

What are types of transport files?

8008

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1915

During the running session, output files are created by informatica server. Enlist few of them.

983

How does hashing happens in teradata?

1092

What olap capabilities do I have within a microstrategy report services document?

926

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1958

In how many ways we can create ports?

1124

Performance tuning in UNIX for informatica mappings?

2570

How can we use batches?

1026

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