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?
Mention what the difference between “look-up” file and “look is up” in abinitio?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
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.
When we should use 'jobid' for commit table (Output table component??
How can you import XML repositories exported from different tools like ODI
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
How data is processed and what are the fundamentals of this approach?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What do you mean by a transaction file?
Explain what does dependency analysis mean in abinitio?
What are the features of ab initio?
What are the steps to create a repository in ab initio?