Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 8532

what is main functional differences between BO and COGNOs?

TCS,

5 12402

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

iGate,

6 10966




SAS System ?

5 7573

sas macros

TCS,

12 17574

how to test reports in businessobjects?

TCS,

8 47168

What is source qualifier?

2 6504

Difference between DSS & OLTP?

IBM,

6 39057

Explain grouped cross tab?

1606

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14711

How many repositories can we create in Informatica?

Informatica,

14 17769

What is surrogate key?

IBM, Informatica,

5 16819

What is difference between Mapplet and reusable transformation?

UST,

3 3430

What is aggregate awareness?

2 5137

Explain reference cursor?

1152







Un-Answered Questions { Data Warehouse }

Where we use surrogate key explain with example?

7


HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

3334


what is the difference between cardinality and Nullability?

2174


any one answer me how they can analyzing the project using data ware housing?

1455


What are the different types of sas functions?

29






How to know the time taken for particular report execution?

11


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

536


How we drill up week to month?

12


-------------What is Coditional Prompting?

917


Why fact table is in a normal form?

11


What is a bridge table ?

19


How to add default rules in transformer?

25


explain about citrix scheduling tool in datastage

1208


What is initial load and what is full load?

12


What is by-group processing?

24