Q&A Categories

Abinitio

Why might the optimizer use a table scan when an index is available?

Why might the optimizer use a table scan when an index is available? '

Answers No Answers In: Abinitio By: ramesh [ Grey Star Level] Sep 6, 2010

Why might you create a stored procedure with the 'with recompile' option?

Why might you create a stored procedure with the 'with recompile' option? '

Answers No Answers In: Abinitio By: samir [ Grey Star Level] Sep 6, 2010

Which one is faster for processing fixed length dmls or delimited dmls and why ?

Which one is faster for processing fixed length dmls or delimited dmls and why ? '

Answers No Answers In: Abinitio By: jes [ Grey Star Level] Sep 5, 2010

When using multiple DML statements to perform a single unit of work, is it preferable to use implicit

When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why. '

Answers No Answers In: Abinitio By: ashok [ Grey Star Level] Sep 3, 2010

Where we keep the control file (controle partition)

Where we keep the control file (controle partition) '

Answers No Answers In: Abinitio By: bipin [ Grey Star Level] Sep 3, 2010

When running a stored procedure definition script how would you guarantee the definition could be "rolled

When running a stored procedure definition script how would you guarantee the definition could be "rolled back" in the event of problems. '

Answers No Answers In: Abinitio By: @mahesh@ [1 Grey Star Level] Sep 3, 2010

Whats the best way in a AI GRAPH to read the header 1st line and trailer (last line) in a i/p file,

Whats the best way in a AI GRAPH to read the header 1st line and trailer (last line) in a i/p file, compare record counts and checksum (available in header) and error out if actual recd count or checksum...

Answers No Answers In: Abinitio By: deva [1 Grey Star Level] Sep 2, 2010

What r the Graph parameter?

What r the Graph parameter? '

Answers No Answers In: Abinitio By: ravi [ Grey Star Level] Sep 1, 2010

What is wrapper script in Ab initio

What is wrapper script in Ab initio '

Answers No Answers In: Abinitio By: ramesh [ Grey Star Level] Sep 1, 2010

What is writing of wrapper can any explain elaborately

What is writing of wrapper can any explain elaborately '

Answers No Answers In: Abinitio By: jes [ Grey Star Level] Sep 1, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]