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
Explain the methods to improve performance of a graph?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Mention some file extensions which are used in abinitio?
How do you add default rules in the transformer?
What is a partition?
What are the different types of parallelism in ab initio?
Mention some ways for improving performance of a graph?
What is the purpose of having stored procedures in a data-based?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
What are the benefits of data analyzing?
How to add default rules in the transformer?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
How to create repository in abinitio for stand alone system(local nt)?
What do you mean by the term data warehousing?
what is the project environment(for each project the environment is same or different to different project)?