Data Warehouse Developer interview questions – page 26

What is the max capacity of Hash file in DataStage?

What is Object Auditing ?

What is a window?

Why is my slide show playing in a window?

What are roles? How can we implement roles ?

What is Log Switch ?

All the users are complaining that their application is hanging. How you will resolve this situation in OLTP

What is the meaning of the following..1)If an input file has an excessive number of rows and can be split-up then use standard 2)logic to run jobs in parallel3)Tuning should occur on a job-by-job basis. Use the power of DBMS.

What is the use of ANALYZE command ?

System.effective_date system variable is read only True/False?

How do I enter text into a document?

Describe Referential Integrity ?

What is a Data Dictionary ?

Can you attach an lov to a field at run-time? if yes, give the build-in name.?

In WordPerfect, I could point to a blank part of the page and start typing. Can Word do that?

I'm trying to open *.wmf files, and just get garbage. What do I do?

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

I like WordPerfect. Where are the "Reveal Codes"?

What is a radio Group?

How do you know that a PO is created based on which requisition?

What are the types of Database Links ?

What are the display styles of an alert?

What is a record Group?

What is a slide transition and how can I create transitions?

What is the built-in function used for finding the alert?

How do I turn-off the Auto Correct feature?

How to do the scheduled task/jobs in Unix platform

Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B

Can I use the SHOW menu to remove revisions from a document?

How can you implement Complex Jobs in datastage