Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 10940

what is main functional differences between BO and COGNOs?

TCS,

5 14994

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

iGate,

6 14490

SAS System ?

5 10524

sas macros

TCS,

12 24365

how to test reports in businessobjects?

TCS,

8 51259

What is source qualifier?

2 8325

Difference between DSS & OLTP?

IBM,

6 48572

Explain grouped cross tab?

2167

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17438

How many repositories can we create in Informatica?

Informatica,

14 24242

What is surrogate key?

IBM, Informatica,

5 20156

What is difference between Mapplet and reusable transformation?

UST,

3 5602

What is aggregate awareness?

2 6548

Explain reference cursor?

1672


Un-Answered Questions { Data Warehouse }

What is the use of powerplay web viewer in cognos?

529


How do you delete duplicate observations in sas?

544


Explain attribute role?

592


What are stage variables?

610


We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

540






A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

652


What is data stream and data adaopter?

574


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1636


what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

576


What is difference between user and database in teradata?

584


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1809


How to know the time taken for particular report execution?

500


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

755


What is data movement mode in Informatica and difference between them?

596


What are the enhanced features in teradata v2r5 and v2r6?

664