Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is factless fact schema?

2 5632

What is confirmed dimension?

JPMorgan Chase,

7 13888

What is the capacity of power cube?

2 5700

Difference between PowerPlay transformer and power play reports?

CTS,

2037

What is IQD file?

1 4756

What is Cognos script editor?

2055

What is difference macros and prompts?

1691

What is power play plug in?

3 3612

Which kind of index is preferred in DWH?

1 7872

What is hash partition?

TCS,

3 3964

What is DTM session?

1 7908

How can you define a transformation? What are different types of transformations in Informatica?

TCS,

7 8774

What is mapplet?

1 5237

What is query panel?

1 3143

What is a look up function? What is default transformation for the look up function?

1 3936


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is VLDB?

594


What is the very basic difference between data warehouse and operational databases?

438


How to define a cube??

527


Explain what is the difference between datawarehouse and bi?

500


What needs to be done when the database is shutdown?

530






What are the stages that are required in data warehousing?

492


What is the main difference between star and snowflake star schema? Which one is better and why?

538


Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

493


How can we run the graph? How can we schedule the graph in unix?

478


What is a full backup?

525


What are components of report studio?

513


Explain what is the extension of file to save template?

492


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5243


What is surrogate key? Explain with examples.

580


What is vldb(very large databases)?

524