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

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

CSC,

5 18230

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

iFlex,

2149

what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me

IBM,

4 9005

how can you improve the performance of a query, If it is excuting very slowly?

Zensar,

2 7312

wt is a-z and a--z?

Accenture,

3 8827

how can u join the two tables without using proc sql Joins and nested queries ?

IBM,

6 13577

WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION?

IBM, Zensar,

3 13381

HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?

Accenture, Novartis,

3 10316

CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE

CybAge,

4 8129

Difference between drill by and drill across with example?

TCS, WNS,

4 23939

Un-Answered Questions { Data Warehouse }

5. How many repositories can we create in Informatica? 6. What is surrogate key? 7. What is difference between Mapplet and reusable transformation? 8. What is aggregate awareness? 9. Explain reference cursor? 10. What are parallel querys and query hints? 11. DWH architecture? 12. What are cursors? 13. Advantages of de normalized data? 14. What is operational data source (ODS)? 15. What is meta data and system catalog? 16. What is factless fact schema? 17. What is confirmed dimension? 18. What is the capacity of power cube? 19. Difference between PowerPlay transformer and power play reports? 20. What is IQD file? 21. What is Cognos script editor? 22. What is difference macros and prompts? 23. What is power play plug in? 24. Which kind of index is preferred in DWH? 25. What is hash partition? 26. What is DTM session? 27. How can you define a transformation? What are different types of transformations in Informatica? 28. What is mapplet? 29. What is query panel? 30. What is a look up function? What is default transformation for the look up function? 31. What is difference between a connected look up and unconnected look up? 32. What is staging area? 33. What is data merging, data cleansing and sampling? 34. What is up date strategy and what are th options for update strategy? 35. OLAP architecture? 36. What is subject area? 37. Why do we use DSS database for OLAP tools?

2772

explain what is data set in sas? : Sas-administrator

1042

Define project in datastage?

1153

define junk dimension?

Describe expression transformation?

1172

what is session partitioning?

1929

what is dynamic insert?

2257

What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

1005

What is the difference between a primary and secondary actor in use case modeling?

1135

how to explain health care project and which reports we can create in health care doain?

6854

What is substr in informatica?

1270

Mention what is the difference between nodupkey and nodup options?

1062

What is Linear Regression?

1225

How can you first report in Business Objects by using broadcast agent?

3110

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6987

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