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

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1019

What is difference between primary key and unique key constraints?

950

Define query items?

971

What are the different uses of a repository manager?

1038

Define dimensions?

983

Why need staging area database for dwh?

1035

What are shortcuts? Where it can be used? What are the advantages?

1008

Give the advantages of cognos?

996

Name the types of gateway?

971

Explain the characteristics of cognos?

1002

Name the types of report?

917

What are the advantages of shortcuts?

925

Define olap designer?

1081

Define report item?

1115

Can you define drill across?

932

Un-Answered Questions { Data Warehouse }

if i have a query as flat file how can we load data to target table

1352

What are the steps required to kill the job in Datastage?

1164

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1023

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1086

How long does it take to get microstrategy desktop up and running?

958

How would you determine the number of missing or nonmissing values in computations?

1024

can cubes contain measures ?

1991

Pdl with an example?

1054

What are all difference between business objects 6.5 and xi r2?

982

Mention what the difference between “look-up” file and “look is up” in abinitio?

1268

Explain what are the methodologies of data warehousing?

881

How to know the time taken for particular report execution?

915

Explain vproc in teradata?

943

What is load manager?

992

Mention what dedup-component and replicate component does?

991

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