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 users and permissions in cognos?

IBM,

4 21119

How to test reports in cagonos ?

CST, CTS,

10 29743

How to create a dynamic column name in Cognos?

Aditya Birla, Polaris,

6 38801

what is model and how to create model and how to test model?

IBM,

8 17270

In Microstrategy, how can you direct the sql generated to use a specifc table?

5 12955

In Microstrategy, what are Logical Views used for?

InfoCepts, Marlabs, Tech Mahindra,

6 25080

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

IBM,

1 9256

what is the difference between start schma and Fsldm?

Intel,

5 50026

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

IBM, Wipro,

2 12962

What are two examples of an OLTP environment?

4 14880

What is a common data source for the central enterprise data warehouse?

Wipro,

1 11406

Does SDLC changes when you use Teradata instead of Oracle?

2 11557

What are the new features of informatica 7.1?

2 7369

What are teh different tasks that can be created in workflow manager?

NIIT,

1 10054

What is the functionality of update strategy?

2 9259

Un-Answered Questions { Data Warehouse }

What is the function of surrogate key in data warehousing?

1065

for what purpose would you use the retain statement? : Sas programming

1096

What is the difference between business requirement document and use case document.

1009

What are the different types of transformation available in informatica.

1105

4 yrs etl devloper roles and responsibilities?any body give solutions

2168

What are the different types of reports present in cognos?

986

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032

have u done any performance tuning? how u ll do?

2299

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

5113

flat filevalidation in informatica

2154

Is AWS redshift is one of the RDS in AWS or is it Relation Database?

What was the last computer book you purchased? Why?

2374

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

928

What is the use of datastage director?

1017

Mention what is SAS data set?

1132

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