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 Drill filter and it's usage?

2 11179

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2513

in which scenario we go for views in cognos or oracle?

1 6788

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2137

what is degenerate key in oracle ?whare do we use it?

2618

Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

Wipro,

2 5932

bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?

PCS, TCS,

7 14342

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

iFlex, Morgan Stanley,

6 17271

How can i optimize a report in microstrategy environment?

IBM,

1 9920

One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..

TCS,

4 27178

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

Satyam,

7 14612

Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 7063

what is the difference b/w star and snowflack schema in dataware house?

8 12317

Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance

1 5735

Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)

BirlaSoft, TCS,

3 10369

Un-Answered Questions { Data Warehouse }

What is static prompt in microstrategy?

1020

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2453

Explain what are the different methods of loading dimension tables?

999

How do dates work in SAS data?

1232

How to extract sap data using informatica?

1098

How to Reset Pagenumbers in one report.

2716

What is the format of informatica objects in a repository?

1080

what is function of retain statment

2085

Explain what are the methodologies of data warehousing?

976

What is the main difference between star and snowflake star schema? Which one is better and why?

1086

name the sub-tabs which are in advance tab of ti?

What are the different types of scd's used in data warehousing?

1295

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2466

what is snowflake schema? : Sas-di

1268

What are logical views used for in microstrategy?

1021

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