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 a prompt value in report studio and variables ?

2729

What are the types of tables in Teradata

Cap Gemini, Cognizant, Infosys,

22 78815

How to call a stored procedure from a report?

1 7344

1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?

CTS,

1 7014

After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?

1 2946

What is difference between (a-z) and (a--z)

Accenture,

8 21145

Can anybody pls provide me Business Objects Certification (SABE201) Study material and dump. Pls. My email id is reshma.toppo@gmail.com......Thanx

4 8427

Pls Explain about the different between 6.5 & Xi R2

IBM,

2 7339

How to Shedule the reports in Xi R2

iFlex,

3 7503

What are the Errors in BO Pls Explain with Examples

iFlex, Tech Mahindra,

2 15155

What are the join problems comes appart from loop,chasm & fan Traps

IBM,

2153

Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important

Zylog,

7 11337

Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

IBM,

1 6090

what is meaning by Master detailed relationship ? please explain one example

4 17543

how many facts&dimensions tables in project? it's very urgent.........

2 6106

Un-Answered Questions { Data Warehouse }

What dedup-component and replicate component does?

1293

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1245

What is workflow monitor?

1075

What are initial page components of Cognos connection?

1025

What are connected or unconnected transformations?

1133

How to extract sap data using informatica?

1063

Explain multivalued dependency?

1001

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2192

What are the join problems comes appart from loop,chasm & fan Traps

2153

Enlist some properties of sessions.

1102

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1106

Explain what are the vaious etl tools in the market?

957

What are shortcuts? Where it can be used? What are the advantages?

1090

How scientific data processing is different from commercial data processing?

1101

Explain how are the dimension tables designed?

1072

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