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 to create model and how to test model?

1029

What is cognos connection?

1303

Which lifecycle we will use for reporting?

981

How create measures and dimensions?

1083

How to generate cubes in cognos?

977

What is the difference between the standard and metrics folder?

974

What is the difference between a data mart and a data warehouse?

1046

What is the difference between the content store and content manager?

1044

What are the types of hierarchies?

1026

What is dtm?

1174

WHat all joins are there in Source Qualifier?

1 2559

What all join we can perform in LOOKUP transformation?

986

Difference between Target-based loading and constraint-based loading?

1009

Ist the schema that a data warehouse system can implements.

943

What is the very basic difference between data warehouse and operational databases?

972

Un-Answered Questions { Data Warehouse }

Explain the mapping variable usage example in informatica

1167

Explain some of modeling tools available in the market?

969

how to abort the job its matain duplicates?

2576

Distinguish between cognos dynamic cube and transformer/tm1 cube and powerplay cube?

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4167

What is called data cleaning?

1245

What is VLDB?

1072

what is the size of u r source(like file or table)?

2275

What are the default statistics for means procedure?

1254

Differentiate between sessions and batches?

1023

What are the differences between source qualifier and joiner transformation?

1065

What are the limitations for memory allocation for SAS variables

1499

What is a connected transformation?

1127

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1922

In ARRAY processing, what does the DIM function do?

1179

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