Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 8176

what is main functional differences between BO and COGNOs?

TCS,

5 11975

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

iGate,

6 10604




SAS System ?

5 7047

sas macros

TCS,

12 16425

how to test reports in businessobjects?

TCS,

8 46114

What is source qualifier?

2 6174

Difference between DSS & OLTP?

IBM,

6 37245

Explain grouped cross tab?

1523

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14235

How many repositories can we create in Informatica?

Informatica,

14 16965

What is surrogate key?

IBM,

5 16200

What is difference between Mapplet and reusable transformation?

UST,

3 3031

What is aggregate awareness?

2 4865

Explain reference cursor?

1066







Un-Answered Questions { Data Warehouse }

how to merge 2 crosstabs thans

1418


Why might the optimizer use a table scan when an index is available?

1016


What is granularity? Please explain with example

317


COM components can be used in Informatica

1123


What are algorithms provided by Microsoft in SQL Server?

962






what is repositery?

550


can you tell me what are the dimension tables are used in project

1217


How to deploy from one server to another server?

1351


What is confirmed fact in dataware housing?

4144


how do u implement configuration management in Informatica?

3736


hoe to access second value in mapping parameter if it is having more than one value ?????????????

482


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

210


hi,can you please share with me about,what is reportlimit,report order and how can create and use

3179


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

844


how do u extract data from different data sources explain with an example?

1119