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

What is tracing level and what are the types?

908

Can there be sub steps of etl steps?

960

What are the etl testing operations includes?

1055

What are the various tools used in etl?

989

What is partitioning? Explain different types of partitioning?

1170

What do you understand by active and passive transformations?

895

What are the names of the layers in etl?

952

What are the different etl testing categories as per their function?

1017

how many steps are there in etl process?

931

What is meant by incremental load?

1026

Compare etl & elt?

955

What dedup-component and replicate component does?

1232

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

1315

What is the role of co-operating system in abinitio?

1397

What is a look-up?

1143

Un-Answered Questions { Data Warehouse }

Explain where to store informatica rejected data? How to extract the informatica rejected data?

964

whom do you report?

1889

Explain the term 'tables' related to relational database management system?

988

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2055

What is a joint child?

902

Can you define drill down and drill up?

1002

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7339

Explain the features of connected and unconnected lookup.

889

What is an enterprise?

988

How you prepared reports for OLAP?

1562

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

5024

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2003

What is parallel processing in informatica?

1638

How we are using this function?

1058

what are the different views that are considered when building an object-oriented software system?

988

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