Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 11036

what is main functional differences between BO and COGNOs?

TCS,

5 15086

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

iGate,

6 14641

SAS System ?

5 10621

sas macros

TCS,

12 24546

how to test reports in businessobjects?

TCS,

8 51407

What is source qualifier?

2 8388

Difference between DSS & OLTP?

IBM,

6 48739

Explain grouped cross tab?

2191

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17505

How many repositories can we create in Informatica?

Informatica,

14 24458

What is surrogate key?

IBM, Informatica,

5 20254

What is difference between Mapplet and reusable transformation?

UST,

3 5668

What is aggregate awareness?

2 6598

Explain reference cursor?

1691


Un-Answered Questions { Data Warehouse }

What are the methods by which it non-durable model could be changed into the durable model?

518


What are the different type of jobs in datastage?

602


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

1948


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10734


Name any two sas spawners? : sas-grid-administration

555






1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1623


what is granularity in Data ware House?

1162


Can you explain cognos planning?

659


What needs to be done when the database is shutdown?

546


Under what condition selecting sorted input in aggregator may fail the session?

655


Explain about power designer data modeling software?

459


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1447


Why did ibm cognos tm1 web change the technology from .net to java?

5


What is dimension modeling?

530


1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3101