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

----------------Describe DWH Architecture?

Bank Of America,

2020

-------------How you design DWH?

Bank Of America,

2256

-------------How to create a PortalTab?

Cap Gemini,

1 5064

-------------How to do Bursting a Report?

Cap Gemini,

1 6550

--------------Explain Table of contents?

Cap Gemini,

1980

----------------Diff b/w Dimensional modeling and Relational modeling?

Cap Gemini, L&T,

2 14899

-------------Diff b/w Union and Unionall?

Cap Gemini,

3 9119

-----------------What is Singleton?

BoA, Cap Gemini, TCS,

1 16744

-------------------What is StarShema?

Cap Gemini,

1 5239

------------------What is Inline Query?

Cap Gemini,

2180

----------------What is Surrogate Key?

Cap Gemini,

1 6726

Diff b/w surrogate Key and Primary Key?

Cap Gemini,

2 8671

------------------What is Focalpoint?

1 3979

------------------- What is Busschema?

Cap Gemini,

1 5575

--------------what is MemberCaption?

1 4606

Un-Answered Questions { Data Warehouse }

when will use SQL override in a lookup transformation?

2233

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2286

How can you create a macro variable with in data step? : sas-macro

1001

how do you want missing values handled? : Sas programming

904

How would you increase the logical size of a table in microstrategy?

920

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1391

What are the advantages of cold fusion?

913

What are the programs that we can do with the microstrategy architect?

986

What is the order of application for output data set options, input data set options and SAS statements?

1508

If a variable contains only numbers, can it be a character data type?

1038

What is a repository? And how to add it in an informatica client?

1095

What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.

2553

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1005

What olap capabilities do I have within a microstrategy report services document?

880

What is data transformation manager process?

1090

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