Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 8876

what is main functional differences between BO and COGNOs?

TCS,

5 12777

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

iGate,

6 11404

SAS System ?

5 8187

sas macros

TCS,

12 18644

how to test reports in businessobjects?

TCS,

8 47978

What is source qualifier?

2 6749

Difference between DSS & OLTP?

IBM,

6 40448

Explain grouped cross tab?

1694

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 15020

How many repositories can we create in Informatica?

Informatica,

14 18677

What is surrogate key?

IBM, Informatica,

5 17377

What is difference between Mapplet and reusable transformation?

UST,

3 3731

What is aggregate awareness?

2 5322

Explain reference cursor?

1232







Un-Answered Questions { Data Warehouse }

How to limit decimal places for the variable using proc means?

116


How to hide certain columns from a user?

79


How to create list output for cross-tabulations in proc freq?

107


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

2349


How will change port of obiee answers?

89






how to read the variables in sas? : Sas-administrator

77


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

80


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

3469


Compare aggregates and data marts

1712


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

1407


What is proc sort?

118


U r project in which stage in implementation?

1445


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1109


what is data modeling?

977


What is real-time datawarehousing?

96