Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 10990

what is main functional differences between BO and COGNOs?

TCS,

5 15039

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

iGate,

6 14589

SAS System ?

5 10585

sas macros

TCS,

12 24480

how to test reports in businessobjects?

TCS,

8 51347

What is source qualifier?

2 8356

Difference between DSS & OLTP?

IBM,

6 48690

Explain grouped cross tab?

2179

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17479

How many repositories can we create in Informatica?

Informatica,

14 24394

What is surrogate key?

IBM, Informatica,

5 20212

What is difference between Mapplet and reusable transformation?

UST,

3 5642

What is aggregate awareness?

2 6580

Explain reference cursor?

1684


Un-Answered Questions { Data Warehouse }

What is star schema and snowflake schema?

523


How do you verify a complicated sql?

613


What are logical views used for in microstrategy?

521


What are the various indexes in teradata? How to use them? Why are they preferred?

583


Is it possible to access Redshift compute Nodes directly?

5






can we insert all types of charts in a list report? what r the realtime prompts?

1652


Explain is there any default username & pwd for bo designer & supervisor?

582


How to extract the informatica rejected data?

737


where are dashboard components are created and maintained? : Sas-bi

543


Define project in datastage?

654


What is powercenter on grid?

680


You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?

504


How can we Maintain the Cube Security by Category level and Dimension level ?

1945


What are the data types present in bo? What happens if we implement view in the designer and report?

606


What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

849