GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Abinitio
Go To First  |  Previous Question  |  Next Question 
 Abinitio  |  Question 68 of 193    Print  
What is AB_LOCAL expression where do you use it in ab-initio?

  
Total Answers and Comments: 3 Last Update: April 13, 2006     Asked by: rupal 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
March 07, 2006 11:43:30   #1  
ramana        

RE: What is AB_LOCAL expression where do you use it in...

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.


 
Is this answer useful? Yes | No
April 02, 2006 08:24:25   #2  
atish_ban Member Since: April 2006   Contribution: 9    

RE: What is AB_LOCAL expression where do you use it in...

one example is, if you want to use oracle hint in your select query at input table...u should use AB_LOCAL(table) to parse the query at Database sQL engine not by AI parser.

It is mainly used at parallel unload.


 
Is this answer useful? Yes | No
April 12, 2006 23:29:00   #3  
sekr Member Since: December 2005   Contribution: 42    

RE: What is AB_LOCAL expression where do you use it in...

in some cases abinitio will not recognize some part of  sql statments and unable to read the table.. to avoid this we have use AB_LOCAL() and table name when ever we use clauses like WHERE condition


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape