Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 11185

what is main functional differences between BO and COGNOs?

TCS,

5 15259

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

iGate,

6 14902

SAS System ?

5 10780

sas macros

TCS,

12 24943

how to test reports in businessobjects?

TCS,

8 51639

What is source qualifier?

2 8521

Difference between DSS & OLTP?

IBM,

6 49030

Explain grouped cross tab?

2222

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17642

How many repositories can we create in Informatica?

Informatica,

14 24890

What is surrogate key?

IBM, Informatica,

5 20426

What is difference between Mapplet and reusable transformation?

UST,

3 5786

What is aggregate awareness?

2 6693

Explain reference cursor?

1727


Un-Answered Questions { Data Warehouse }

What are the different types of mstr objects?

552


what is a worklet?

575


Explain when to use local filter and when to use global filter?

656


What is the use of datastage designer?

677


Can tm1 web be set up for load balancing?

5






what are the facilities provided by data warehouse to analytical users?

1701


What do you mean by ttu in teradata?

606


Can we create universe with no cache??

1996


which date function advances a date, time or datetime value by a given interval? : Sas programming

631


How do you see a ddl for an existing table?

611


What do you understand by the term 'aggregate cache'?

598


What does PROC print, and PROC contents do?

776


Explain different types of partitioning?

648


What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

745


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

676