Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 12954

what is main functional differences between BO and COGNOs?

TCS,

5 17362

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

iGate,

6 17515

SAS System ?

5 13003

sas macros

TCS,

12 29222

how to test reports in businessobjects?

TCS,

8 54443

What is source qualifier?

2 10374

Difference between DSS & OLTP?

IBM,

6 52026

Explain grouped cross tab?

2677

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 19285

How many repositories can we create in Informatica?

Informatica,

14 29479

What is surrogate key?

IBM, Informatica,

5 22783

What is difference between Mapplet and reusable transformation?

UST,

3 7731

What is aggregate awareness?

2 8134

Explain reference cursor?

2227

Un-Answered Questions { Data Warehouse }

Design a mapping to load the cumulative sum of salaries of employees into target table?

1557

Which are the statements whose placement in the data step is critical?

1315

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2543

What is a shortcut and copy in Informatica and how two are different with each other?

1245

Do you know the features of sas?

1098

Highlight the main features of datastage?

1222

Can you explain the process of calendar?

1161

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

2190

How can we remove the duplicates from flat file source?

1075

What is Index Caches size?

1165

What are the functions performed by bynet?

1092

describe how to adjust the performance of data integrator? : Sas-di

1070

What are the designer tools for creating transformations?

1160

Mention common programming errors committed in sas ?

1175

what is operational data and operational system? : Sas-di

1159

For More Un-Answered { Data Warehouse } Questions Click Here