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 difference btw proc means and proc univariate?

HSBC, TCS,

8 51939

What is the difference between running total and sub-total?

5 22072

How can we performance tune reports?

1 9916

What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?

Perot Systems,

3 9981

what is data cubes??

2 5289

What are the different types of Filters available in BUSINESS OBJECTS?

3 20435

what is canned universe and canned reports in bo?

1 10181

What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

Cap Gemini, Deloitte,

6 23945

How would I achieve Traffic Lighting in Business Objects

Virtusa,

3 8498

What is the difference btw reportnet - Report studio and cognos 8 - Report studio

Dominion,

3 9311

How can we find out cardinality between two tables?

Dominion,

3 10363

what are determinants?

Dominion,

4 12270

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

TCS,

2059

what is difference btw summary filter and detail filter, plz explain with example

IBM, TCS,

10 54267

What is difference between rename and lable in sas?

Satyam,

10 31552

Un-Answered Questions { Data Warehouse }

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1016

What are the available primary index types in teradata.

1033

What are the different kinds of views available in a datastage director?

1031

Write a program to show the parser component used in teradata?

977

How many types of transformations supported by sorted input?

1224

What do you mean by caching in teradata?

1065

what are the concerns of OLTP and DSS systems?

1962

Explain conformed fact?

973

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955

Mention what is the syntax for m_dump in abinitio?

1476

What is a compound attribute in microstrategy?

1041

Can we use target hash file as a lookup ?

3327

what is pmrep command?

2441

What is data warehouse architecture?

1050

Explain what is the difference between slice and dice and cross tab report?

1079

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