What is AB_LOCAL expression where do you use it in ab-
initio?

Answer Posted / alok

we use AB_LOCAL(expression) to increase the SQL query
performance by supplying the name of large table in
expression. This way we make it as a driving table.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the Graph parameter?

910


What are the benefits of data analyzing?

881


What is conduct>it?

860


What is the difference between rollup and scan?

1508


What is the max core of a component?

798


What are the factors on which storage of data depends?

842


What are the different types of partition components in abinitio?

1045


Within a cursor, how would you update fields on the row just fetched?

828


Define ramp limit in ab initio?

982


What is sort component in abinitio?

885


What is the difference between sandbox and EME?

942


What is broadcasting and replicate?

896


How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

692


What are the primary keys and foreign keys?

757


What are the features of ab initio?

842