Data Warehouse Developer interview questions – page 20

What is use of APPCORE library?

What is event handler package?

What is relation between the window and canvas views?

What is Weak Entity set?

Why we can't create an aggregate on an ODS Object?

What is a difference between pre-select and pre-query?

What is naming convention for Data base trigger?

Why do we need immutable objects?

What is optimization and performance tuning and How does it work in practical projects. Explain with an example.

What is naming convention for Primary key Constraint?

How will you enforce security using stored procedures?

What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it

Can you use a commit statement within a database trigger?

How do I get Animated GIF files to play in Slide Show?

Explain different types of segment. Data segment, Index segment, Rollback segment and temporary segment.

How to turn off Office Assistant?

How can I specify a filter command for processing data while defining sequential file output data?

What is oracle d2k? why we use it?

How to handle the rejected rows in datastage?

What are the minimum parameters should exist in the parameter file (init.ora) ?

Write the Abbreviation for the following File Extension1. FMB 2. MMB 3. PLL

Difference between database triggers and form triggers?

What happens to output when hash file is connected to transformer ..What error it throws

What is the difference between Datastage and Datastage TX?

How can you do incremental load in datastage?

If you increase the size of the database naturally the memory has to be increased for better performance.What is the proportion in which the memory has to be added for the corresponding increase in the disk space?

SGA definition files

How do I use the Clipboard?

What are the steps involved in Instance Recovery ?

What is the use of Control File ?