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 can you communicate with web server (apache or iis) from coldfusion?

1126

What is cfapplication tag?

976

What is application.cfm?

1057

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1188

What are templates in which way it is help full?

1004

What is data stream and data adaopter. Is it same are different? Explain?

1024

How to create diff. Types of templates?

1056

What is freehand sql?

1056

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

945

List down some of the real time data-warehousing tools?

985

What is a view as it relates to system modeling?

988

What are snapshots? What are materialized views & where do we use them?

1050

Explain what are data marts?

1131

What are the various tools? Explain name a few?

968

Explain what is data validation strategies for data mart validation after loading process?

1040

Un-Answered Questions { Data Warehouse }

------------------What is Inline Query?

2231

how to create user defined function (udf) in informatica

1315

How to move or copy the project parameter or project object to my sandbox?

2318

What is the main difference between inmon and kimball philosophies of data warehousing?

1125

What is xml source qualifier transformation in informatica?

1227

What are the five ways to do a table lookup in sas? : sas-grid-administration

1073

What if the source is a flat-file?

1125

What are the measure objects?

1215

How would you configure wh authentication?

957

What is Index Caches size?

1125

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

997

What is workflow? What are the components of the workflow manager?

1151

Can you explain how could anyone drop the index before loading the data in target in datastage?

1511

why do u need the IOS upgradation in a FC switch

2289

What are the difficulties u faced while doing vital signs table or dataset?

2402

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