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?

1127

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?

1191

What are templates in which way it is help full?

1006

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

1026

How to create diff. Types of templates?

1058

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?

947

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

990

What is a view as it relates to system modeling?

988

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

1052

Explain what are data marts?

1131

What are the various tools? Explain name a few?

970

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

1040

Un-Answered Questions { Data Warehouse }

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1281

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1180

What is the core of co> operating system?

1193

What is execution plan?

1210

Explain adhoc reports?

947

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2362

what is intially documentation in sas?

5069

If informatica has its scheduler why using third party scheduler?

1276

why is sas considered self-documenting? : Sas programming

1158

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2088

Diff b/w Crossproduct and Outerjoin?

2295

How are the sources and targets definitions imported in informatica designer?

1121

What are the methodologies of data warehousing?

1001

Have you used the rollup component? Describe how?

1132

How the Bursting happens in same report and how to Print the bursting Report?

1871

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