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

what is an ETL or ETT? And what are the different types?

7495

how do u extract data from different data sources explain with an example?

2244

what are the reporting tools and difference between them?

2090

how do u automate Extraction process?

1 4807

without using ETL tool can u prepare a Data warehousing and maintaining?

3 8139

how do u identify the changed records in operational data?

QualTech,

2527

what is SMP AND MPP?

8 64468

what are the facilities provided by data warehouse to analytical users?

2081

what are the facilities provided by OLAP to analytical users?

1 4722

what is HISTOGRAM? how to generate statistics?

1 5014

how do u set the size of block buffer?

1 4409

how do u implement unconn.stored proc. in a mapping?

1 4913

if u can't find what you are looking for in lookup table, how do you handle?

1 5246

why oracle is the best database for data warehousing?

HCL,

4 9349

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2127

Un-Answered Questions { Data Warehouse }

Why is business intelligence (bi) important in data warehousing?

941

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1264

Can anyone give me an exaple of realtime start script in the graph?

1053

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1078

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2116

where is the cache (lookup, index) created and how can you see it.

2017

Describe what the SQL Server tempdb and tlog files are used for?

2340

When do we go for the tools in the market?

947

Explain the different lookup methods used in informatica?

1042

What are the different types of security you have worked in obiee?

789

What is staging area referring to?

1128

What is the 4 + 1 view model as it relates to system modeling?

1040

What is application.cfm?

1048

What is the difference in creating filters in designer and business objects?

1025

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3345

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