Data Warehouse Developer interview questions – page 24

What are the different Levels of Auditing ?

What are orabulk and bcp stages?

What is Private Database Link ?

What are the differences between the data stage 7.0 and 7.5in server jobs?

If a DataStage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?

What is Data Block ?

What is a canvas-view?

What is the difference between datastage and informatica

What are the steps to creating a password authentication file?

How does memory compaction work?

If I add a new environment variable in Windows, how can I access it in DataStage?

How to implement routines in data stage,have any one has any material for data stage pl send to me

What is an Lov?

How image_items can be populate to field in forms 4.0?

What are the triggers associated with the image item?

Is there a way to go backwards in an electronic slide show?

What is NLS in datastage?

What is self-referential integrity constraint ?

How do I open PowerPoint?

How do you pass the parameters from one form to another form?

If your running 4 ways parallel and you have 10 stages on the canvas, how many processes does datastage create?

Explain SGA memory structures: Shared Pool, Database buffer Cache, Redo log Cache, Large Pool Java Pool.

Can you change the alert messages at run-time?

What is a Redo Log ?

In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why

How does DataStage handle the user security?

Can a root window be made modal?

How do you control the constraints in forms ?

What are phantom rows?

What are the Job parameters?