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
What do you mean by the term data warehousing? Is it different from data mining?
What are the facts that can compromise data integrity?
Explain what is the architecture of abinitio?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
Why might the optimizer use a table scan when an index is available?
Mention what is a partition and what are the different types of partition components in abinitio?
What are the differences between informatica and abinitio?
What is a rollup component? Explain about it.
What exactly do you understand with the term data processing and businesses can trust this approach?
Mention what is rollup component?
What are the benefits of data analyzing?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
Give one reason when you need to consider multiple data processing?