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 you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
explain checkin and checkout?
What is a data processing cycle and what is its significance?
How to run a graph infinitely?
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
How to create repository in abinitio for stand alone system(local nt)?
How do you improve the performance of a graph?
What do you mean by data sorting?
How to create a repository in abinitio for stand-alone system(local nt)?
What will be the skew for, input file->partition by key-> partition by round robin->output file
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What is the difference between check point and phase?
Have you ever encountered an error called “depth not equal”?
What is a rollup component? Explain about it.
What is the difference between rollup and scan?