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 what is a cube in data warehousing concept?

992

What is the difference between datawarehouse and bi?

969

What is the 4 + 1 view model as it relates to system modeling?

1055

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1143

Explain what is real time data-warehousing?

1117

Explain what is cost benefit analysis (cba)?

981

I need a good brd and uc template?

1097

What are the types of partitioning?

1055

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

938

What is the difference between view filter and report filter?

934

Explain swot analysis?

1172

Explain me what are conformed dimensions?

1045

Which columns go to the fact table and which columns go the dimension table?

969

What is fact less fact table? Where you have used it in your project?

1017

What is pre-emptive and non-pre-emptive?

986

Un-Answered Questions { Data Warehouse }

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2080

Can you explain new content durability?

1037

I need level 2 to 5 sas using companies in india

2393

Hi, If anyone has base SAS certification dumps, please share.

1874

If a Node is busy what are the steps you can take to avoid ?

2421

what is sas and what are the functions? : Sas-administrator

1002

What do high confidence, low confidence and no confidence mean in explain plan?

1058

Explain pmcmd command usage in informatica

1141

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

1016

In Teradata, what is the significance of UPSERT command?

1245

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

5123

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2324

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2246

8. How much supervision have you typically received in your previous job?

2263

How to create a permanent sas data set?

1248

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