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 11087

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 ?)

2449

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

1 6728

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

2072

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

2566

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

Wipro,

2 5825

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

PCS, TCS,

7 14140

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

iFlex, Morgan Stanley,

6 16993

How can i optimize a report in microstrategy environment?

IBM,

1 9810

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 27025

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 14402

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

2 6959

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

8 12011

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

1 5663

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 10263

Un-Answered Questions { Data Warehouse }

expain about the tune parameters?

2421

What is ds designer?

1109

What are the different types of datawarehosuing?

994

What is the complex report you faced in real time?

2184

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

917

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1167

Explain the difference between powerplay transformer and power play reports?

1028

What is the need for an etl tool?

1070

What is Star Schema?

1115

How we can covert server job to a parallel job?

1154

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1054

What are the main components of teradata system?

1139

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1638

What is the difference between a scan component and a rollup component?

1195

Explain the special input delimiters used in sas programming.

1012

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