Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 8309

what is main functional differences between BO and COGNOs?

TCS,

5 12145

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

iGate,

6 10739




SAS System ?

5 7232

sas macros

TCS,

12 16814

how to test reports in businessobjects?

TCS,

8 46530

What is source qualifier?

2 6308

Difference between DSS & OLTP?

IBM,

6 37986

Explain grouped cross tab?

1556

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14416

How many repositories can we create in Informatica?

Informatica,

14 17214

What is surrogate key?

IBM,

5 16461

What is difference between Mapplet and reusable transformation?

UST,

3 3184

What is aggregate awareness?

2 4963

Explain reference cursor?

1098







Un-Answered Questions { Data Warehouse }

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

608


How to publish a package by running Java Script?

958


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1047


I have a few records just I want to store data in to targets cycling way how?

1254


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3138






How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

183


How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

901


write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1368


What are the limitations for memory allocation for SAS variables

228


WHAT ARE THE DISTNICT VARIABLES?

997


what is the difference b/w the refresh and buffered data?

1061


explain abt ur project architecture?

1014


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

1272


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1086


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

868