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 101 of 193    Print  
Explain the differences between api and utility mode?

  
Total Answers and Comments: 4 Last Update: September 22, 2006     Asked by: Godhuly 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 13, 2006 13:18:18   #1  
pavani        

RE: Explain the differences between api and utility mo...

When U load the data into a table in Utility mode,all the constraints are disabled and then data is loaded which leads to faster access.

During API Mode constraints will be enables so that the access will be slow.


 
Is this answer useful? Yes | No
July 06, 2006 03:37:12   #2  
tsrkrishna Member Since: July 2006   Contribution: 1    

RE: Explain the differences between api and utility mo...
These are the Database interfaces
 
Is this answer useful? Yes | No
July 07, 2006 12:34:37   #3  
prabhupurna Member Since: July 2006   Contribution: 22    

RE: Explain the differences between api and utility mo...

API and UTILITY are the two possible interfaces to connect to the databases to perform certain user specific tasks. These interfaces allows the user to access or use certain functions (provided by the database vendor) to perform operation on the databases.The functionality of each of these interfaces depends on the databases.

API has more flexibility but often considered as a slower process as compared to UTILITY mode. Well the trade off is their performance and usage.


 
Is this answer useful? Yes | No
September 22, 2006 17:31:15   #4  
dontbuckme Member Since: September 2006   Contribution: 8    

RE: Explain the differences between api and utility mo...

I think you've the misunderstanding.  Using utility mode does not need to disable constraints nor indexes, if you use the conventional path load (say Oracle).

For direct path, you might need to.

Basically, api mode is using oci calls, so it is much slower.

utility mode is calling the database client utility, e.g. Oracle sqlldr. 


 
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