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

how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?

Cambridge, Patni,

3 12665

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

Accenture,

1 5713

how get the grand total in master-detail report?

Patni,

2236

what is a force compile

Cap Gemini, IBM,

2 9149

what is a message handler

IBM,

3 10849

what is the use of invokation id

IBM,

2 10965

what is a nodemap constraint

IBM,

2 13368

how can we load starting with 11th record of a table from source to target

IBM,

6 10811

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

IBM,

2 6831

can we load the data with out a primary key of a table? what is target plan?

IBM,

6 15182

what is normalizer transformation?

Wipro,

4 7916

What is proc sql pass through facility?

L&T,

4 9757

how eliminate the duplicates in flat file with out using sorter ,aggregater

Wipro,

4 11272

how to load dimension table and fact table. plz tell me the steps.

Cognizant, IBM,

2094

how to load the data to fact table?

2703

Un-Answered Questions { Data Warehouse }

explain html document?

1016

What are the benefits of data processing according to you?

1216

in u r data u having duplicates how to fetch the latest data in our report?

5743

Explain the Roles in mstr?

978

What is data modeling and data mining?

976

What is fact degradation?

976

how could you generate test data with no input data? : Sas programming

1189

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?

2716

Comment whether bottleneck is an error or not.

1159

what is star schema? : Sas-di

1130

What is the command manager?

1002

For what purpose would you use the RETAIN statement?

1524

What is data cleaning? How can we do that?

1044

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2413

What are the partitioning techniques available in link partitioner?

2279

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