Data Warehouse Developer interview questions – page 18

Can we modify all the trigger?

Do you know table based value sets

Why we have to create packages instead of procedures / functions?

What is metadata reporter?

What are logical databases?

What are the designer tools for creating tranformations?

What are the operating systems under which Clipper can operate?

What is the difference between two null values in a column?

What r the types of lookup caches?

What are the Differences between Informatica Power Center versions 6.2 and 7.1, also between Versions 6.2 and 5.1?

What is hybrid slowly changing dimension

What is data validation strategies?

Differences between Informatica 6.2 and Informatica 7.0Yours sincerely

I WANT TO BECOME A DBA ADMINISTRATOR.SO,FOR THAT WHAT CAN I PREPARE NOW?

How can I get 5th highest sal. from employee tab?

What is the difference between PowerCenter 6 and powercenter 7?

1)What ll be in the redolog file after deleting the table ,will it stores the table or any thing else? 2)Can we resize the redolog files?

What is use of FNDSQF library?

If I stopped the concurrent manager, then where and how I can see that concurrent manager is stoped or not??

What is pga ?

What is a Form function?

What is difference between stack and queue?

How many windows in a form can have console?

What is Hyperion? Is it an OLAP tool? what is the difference between OLAP and ETL tools? What is the future for OLAP and ETL market for the next five years?

What is Data Storage - Definition Language?

What are the enhanced features in Teradata V2R5 and V2R6?

How do you define multiple queries in a document?

Compare Custom development & customization. When they are used and Why ?

How can you change the default menu bar action?

What are modalless windows?