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

Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 5198

How will you know the version of Bo using designer?

Tavant Technologies,

4 11325

What is slicing and dicing in business objects?

4 22436

What are the diffrences between Business Objects 5.1 & 6.5 ?

Siemens,

1 7120

What are the security level used in BO?

Oracle,

6 13953

How to Implement the the Built-in Strategy Script in BO Designer?

Infosys,

2 10772

How to link two different universes ?

3 21080

How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

TCS,

1 7167

How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 13290

How does indexing improve query performance?

Satyam,

4 21054

What is the diffrence between Multiload & Fastload interms of Performance?

Cap Gemini, Intel,

8 47914

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 7231

How to select the observations randomly from a SAS dataset

NTT Data,

7 27658

In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)

GSK GlaxoSmithKline,

8 21712

How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take my question is how to use parameter value in the html page .)

JKL, Kudos India,

4 22858

Un-Answered Questions { Data Warehouse }

Difference between star and snowflake schemas?

1263

Can reports be executed in off-peak periods?

1053

Explain substr function?

1169

Explain what is analytical or analytic mean?

1065

How is MLOAD Client System restarted after execution?

1214

Differentiate between a repository server and a powerhouse?

1196

In document how to create metrics?

1049

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2428

Explain the difference between holap and molap?

1113

What is the commit type if you have a transaction control transformation in the mapping?

1102

What Proc glm does?

1154

Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1745

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9907

I need a good brd and uc template?

1148

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1992

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