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 11091

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

2454

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

1 6732

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

2075

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

2572

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

Wipro,

2 5834

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

PCS, TCS,

7 14158

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

iFlex, Morgan Stanley,

6 17016

How can i optimize a report in microstrategy environment?

IBM,

1 9816

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 27030

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 14425

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

2 6970

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

8 12035

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

1 5672

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 10272

Un-Answered Questions { Data Warehouse }

What is cfapplication tag?

976

what is the difference between i)public ii)private iii)common and client projects?

2246

What is TPD?

1384

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3778

Could any one explain me how to create cascading prompts?

1077

What is status code in informatica?

1026

What is the extension of file to save template?

1013

What is a hash cluster?

992

what are sas bi dashboard components? : Sas-bi

1179

how many reports have u created ? explain a few.

2113

We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

910

can we override a native sql query within informatica? How do we do it?

1135

What is the difference between project backlog and product backlog?

1552

How to a create header dynamically in a crosstab report in cognos 8.1?

2446

Can you filter data in hashed file?

3782

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