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

Explain the difference between data ware house & data mart?

953

After the complete generation of a report who will test the report and who will analyze it?

984

What is the difference between snowflake and star schema?

1050

Explain the importance of data warehouse?

1013

How can we run the graph? What is the procedure for that?

946

What is a source qualifier?

1103

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

980

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

911

What is difference between e-r modeling and dimensional modeling?

924

What is a hash cluster?

983

What is data analysis? Where it will be used?

986

What are the methodologies of data warehousing?

992

What is the difference between dependent data warehouse and independent data warehouse?

1007

What is the difference between aggregate table and materialized view?

1100

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1385

Un-Answered Questions { Data Warehouse }

name the window by which you can create your own custom scripts?

What is mean by aggregate aware?

1085

What is a bridge table ?

883

How do you delete duplicate observations in sas?

1072

What is drilling across?

994

What is rank transformation in informatica

1179

What is hybrid slowly changing dimension?

1036

What is fact extension?

1123

What is the difference between slice and dice and cross tab report?

1044

How can you force the optimizer to use a particular index?

1058

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1883

explain the proc in sas? : Sas-administrator

1092

What is report as filter in microstrategy?

917

Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

4078

What is a Folder?

1170

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