Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 8663

what is main functional differences between BO and COGNOs?

TCS,

5 12538

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

iGate,

6 11110




SAS System ?

5 7800

sas macros

TCS,

12 17957

how to test reports in businessobjects?

TCS,

8 47503

What is source qualifier?

2 6590

Difference between DSS & OLTP?

IBM,

6 39643

Explain grouped cross tab?

1647

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14841

How many repositories can we create in Informatica?

Informatica,

14 18126

What is surrogate key?

IBM, Informatica,

5 17030

What is difference between Mapplet and reusable transformation?

UST,

3 3547

What is aggregate awareness?

2 5207

Explain reference cursor?

1183







Un-Answered Questions { Data Warehouse }

What the difference between “look-up” file and “look is up” in abinitio?

63


What are the 3 components in sas programming?

37


Explain what are the steps to do to use alerts in bo?

40


what is the size of u r source(like file or table)?

1213


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1147






What is the difference between Standard and Metrics folder?

64


Compare etl & elt?

54


What do you mean by worklet?

42


Explain snowflake schema?

35


How to enable drills in a given column data?

41


where we cannot use sorter Transformation. if we use then we will not get correct data?

1242


What do you mean by dimensional modeling and relational modeling?

36


What is the difference between filter and lookup transformation?

34


What are the uses of sas?

59


What are the primary usages of datastage tool?

44