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

-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?

IBM,

1 16460

----------0Diff b/w Report Functions and Database functions?

IBM,

1 4244

----------------------What are the User Securities?

IBM,

1904

---------------Tell me about DWH Concepts?

Bank Of America,

2223

--------------Diff b/w ODS and OLAP?

Bank Of America,

3253

---------- Purpose of Factless Facttable?

Bank Of America,

2 8091

----------------What is meant by DSS?

Bank Of America,

1 6626

----------------------Diff b/w MOLAP and ROLAP?

Bank Of America,

4 7743

-------What are the Adv of Star Schema and Snow Flake Schema?

Bank Of America,

4 13820

-----------Types of Fact Tables?

Bank Of America, CTS,

6 22286

---------------Can we use more than 1 Fact table ?

Bank Of America,

2 7103

-------------What is a Conformed Dimension?

Bank Of America,

3 8209

---------------Describe OLAP Reporting and RDBMS Reporting?

Bank Of America,

2152

-----------Diff b/w OLAP and RDBMS?

Bank Of America,

2109

---------------What is Dimension?

Bank Of America,

2 6346

Un-Answered Questions { Data Warehouse }

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2551

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1971

Does an informatica transformation support only aggregate expressions?

1090

Explain what is redshift?

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6985

Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

987

Explain the Roles in mstr?

1034

Where are the source flat files kept before running the session?

1144

how can you create zero observation dataset? : Sas programming

1203

Explain connectivity between datastage with datasources?

1044

Explain access control?

1065

Differences between where and if statement?

1159

what are the dimensions that you have in your current project?list them?

2083

What is drill-through?

1047

What are the different types of partition components in abinitio?

1424

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