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 is data encoding?

832


what is the project environment(for each project the environment is same or different to different project)?

1760


Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

627


What are the components new in 2.14 compared to 1.8 and State the usage of the components?

1815


Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

3653






What is a rollup component?

719


What are the six data process products of ab initio (architecture of ab initio)?

771


What do you mean by the term data warehousing? Is it different from data mining?

784


You can ask about different vector functions. How to use in abinitio graph?

5129


Define ramp limit in ab initio?

863


Hi friends, what are the new features in abinito3.0?

2425


What is the core of co> operating system?

722


Explain what is de-partition in abinitio?

942


What do you know about abinitio?

849


How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

725