Ab Initio Data Warehousing Question:

Download Job Interview Questions and Answers PDF

What is AB_LOCAL expression where do you use it in ab-initio?

Ab Initio Interview Question
Ab Initio Interview Question

Answer:

ablocal_expr is a parameter of itable component of Ab Initio.ABLOCAL() is replaced by the contents of ablocal_expr.Which we can make use in parallel unloads.There are two forms of AB_LOCAL() construct, one with no arguments and one with single argument as a table name(driving table).

The use of AB_LOCAL() construct is in Some complex SQL statements contain grammar that is not recognized by the Ab Initio parser when unloading in parallel. You can use the ABLOCAL() construct in this case to prevent the Input Table component from parsing the SQL (it will get passed through to the database). It also specifies which table to use for the parallel clause.

Download Ab Initio Interview Questions And Answers PDF

Previous QuestionNext Question
How do you convert 4-way MFS to 8-way mfs?What is the latest version that is available in Ab-initio?