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 the difference between Data Level Security and Object Level Security?

1 4479

How do you implement security using External Tables and LDAP?

1 2895

If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?

1 2916

If you want to create new logical column where will you create (in repository or dashboard) why?

1 2472

What is complex join, and where it is used?

1 2540

If you want to limit the users by the certain region to access only certain data, what would you do?

1 2728

If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 2846

How do implement event polling table?

1 3110

Define pipeline. Did you use it in your projects?

1 2578

How do you work in a multi user environment? What are the steps?

1 2506

Can you bypass siebel analytics server security ?if so how?

1 2450

What are the things you can do in the BMM layer?

1 2696

What is the difference between Single Logical Table Source and Multiple Logical Table Sources?

1 5222

How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?

1 2415

How do you know which report is hitting which table, either the fact table or the aggregate table?

1 2577

Un-Answered Questions { Data Warehouse }

How far Redshift is better in performance as compare to other data warehouse technologies?

Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

2324

What is a transaction control transformation?

1214

What are the different types of sas functions?

1286

What is a mapping, session, worklet, workflow, mapplet?

995

Can there be sub steps of etl steps?

1031

How a routine is called in datastage job?

1121

Can we configure two instances of CMS pointing to two different CMS system databases?

2037

explain the use of % includes a statement in sas? : Sas-administrator

1008

Is it possible to join multiple Databases in a Catalog?

1126

How big was your fact table

1806

Define orabulk and bcp stages?

1126

What is the function of output statement in a SAS Program?

1079

What is the difference between datawarehousing and businessintelligence?

1105

What is dimensional table? Explain the different dimensions.

1175

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