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 the use of AFD? Where it can be stored?

1 8871

what is the source for metrics?

2 5992

Why do we need metrics and sets?

1 5338

What are the general issues in migration process?

Deloitte,

3 11634

What is the use of BO SDK?

5 18912

How can we improve performance?

2 7226

How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

HSBC,

5 14956

Can you give an example of any complex report you designed using Actuate?

TCS,

2 9111

how to do pergformence tuning in datastage?

MCA, Symphony, TCS,

4 43709

1.what is context? How u create? With example.

Polaris, TCS,

2 14180

2.What is loop? How resolve the loop?explain it?

TCS, UHG,

11 64307

3.what is alias?

Business Intelligence Analytics, TCS,

5 11303

4.what is repository? types

TCS,

8 18248

5.what is LOV? where it is store?

TCS,

3 14896

6.what is conformed dimension? R u used?

TCS,

8 19913

Un-Answered Questions { Data Warehouse }

Can we collect statistics on multiple columns?

1072

Explain do we need an etl tool? When do we go for the tools in the market?

1029

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1383

Can we collect statistics on table level?

1046

What is the use of the co> operating system in ab initio?

1099

What is rank metrics in microstrategy?

1009

Explain what does level of granularity of a fact table signify?

965

what is hints in cognos and where we use it.

2467

Explain what are the steps to do to use alerts in bo?

1085

What are system variables and sequencers in datastage

1123

What is the use of stored procedures in teradata?

1015

Give some difference between oltp and olap.

1017

Can you run multiple rpd’s in a single obiee instance?

796

Define report item?

1191

what is document design in boxi,have u participate in that

2200

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