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

how do u decide whether u need to do aggregations at database level or at Informatica level?

QualTech,

1 3269

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

2152

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1911

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?

2048

how do u really know that paging to disk is happening while u are using a lookup transform?

2003

how do u set partition points in the mapping?

2612

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2292

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.

1973

what is meant by drill through?(Mascot)

1 2894

what are the different Reporting and ETL tools available in the market?

3 12136

explain the methodology of Data Warehousing?(Polaries)

2319

what are the concerns of OLTP and DSS systems?

1978

what is the difference between OLTP database and data warehousing database?

4 7560

what is data modeling?

1921

what is the difference steps for data modeling?

2154

Un-Answered Questions { Data Warehouse }

How will you create interactive dashboards ?

921

What is source qualifier transformation in informatica?

1030

When do we analyze the tables?

987

explain in detail about type 3?

1032

What is vldb(very large databases)?

1030

define data tab?

Where we use afc in actuate?

1043

How data is processed and what are the fundamentals of this approach?

1165

Can you define materialized view?

1061

Distinguish between informatica & datastage. Which one would you choose and why?

1021

What are the steps to be taken to schedule the report?

979

how much memory space occupied real time project (roughly)?

2242

What was the last computer book you purchased? Why?

2393

Explain the different types of views used in cognos.

961

Write the different types of matrices in microstrategy?

1036

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