Why might the optimizer use a table scan when an index is
available?
No Answer is Posted For this Question
Be the First to Post Answer
How many components in your most complicated graph?
how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?
How does PBK and Sort component and Join(in memory sort) work?I mean in the join component i have used In Memory Sort,so how will it work in terms of performence as compared with PBKand Sort Component?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
What is broadcasting and replicate?
. What is dynamic lookup ?
How do you improve the performance of a graph?
What are the facts that can compromise data integrity?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
Explain what is the architecture of abinitio?
What is de-partition in abinitio?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?