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 filename which you need to configure in UNIX while installing infromatica?

2 15076

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 5677

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

Lanco,

7 22536

What is pragma?

1 5821

What are steps to be taken care to create a good Universe?

2 7972

Explain the SQL Queries activated to data base from Data provider in BO ?

Polaris,

1 4770

What is the test methodology for testing BO Universes?

Cisco, TCS,

3 10928

How to create Universe using Flat file in BO6.0

1 6783

What is the drill up , drill down, drill by , drill trough ?

TCS,

3 21665

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

HCL,

2207

How toconnect one to one report?

iFlex,

4 10098

What are the steps to taken care to improve the Report performance?

3 9428

What is the local filter and global filter in bo's?

8 17754

Explain in Detail about Measure Objects? and what is the use of it? How to create it?

5 10602

How can we acheive Correlated sub-query in Designer?

Infosys, TCCX, Wells Fargo,

2 16072

Un-Answered Questions { Data Warehouse }

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1691

Can anyone give me an exaple of realtime start script in the graph?

1122

What is the difference between microstrategy and cognos reporting tool?

1055

How to join 3 database like flat file, oracle, db2 in informatrica?

1343

What is a merge in datastage?

1354

how to sort two columns in single job in datastage.

2961

What interface is used to connect to windows based applications?

1182

What is non-aggregate metric?

1091

Explain load alternative records / rows into multiple targets - informatica

1213

Tell me about Dnamic and Static Dashboards?

2408

What is the difference between teradata and oracle?

1074

what is sas data set?

1156

What are the main steps to build the data warehouse?

1172

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1126

Explain amp in teradata?

1159

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