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 11188

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

2515

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

1 6797

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

2149

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

2619

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

Wipro,

2 5944

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

PCS, TCS,

7 14364

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

iFlex, Morgan Stanley,

6 17304

How can i optimize a report in microstrategy environment?

IBM,

1 9926

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 27190

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 14652

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

2 7075

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

8 12337

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

1 5741

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 10379

Un-Answered Questions { Data Warehouse }

Explain connectivity between datastage with datasources?

1049

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1123

What is a macro routine?

2804

What is deployment group?

1311

Can any one explain the hierarchies level data warehousing.

1046

Have you used the rollup component? Describe how?

1185

Explain scd type 3 through mapping.

1064

What is domain in terms of informatica?

1074

How to calculate fact table granularity?

1079

what is the use of structures?how many nodes can u create in a structure?

2300

How co> operating system natively processes the data?

1151

in general which algorithms for used?

2084

Explain is data mart?

1077

Why should you put your data warehouse on a different system than your oltp system?

1062

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2423

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