GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PeopleTools
Go To First  |  Previous Question  |  Next Question 
 PeopleTools  |  Question 34 of 39    Print  
what is the use of temporary records and state record in application engine

  
Total Answers and Comments: 4 Last Update: October 29, 2009     Asked by: gnana 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 13, 2007 07:01:48   #1  
sharry Member Since: July 2007   Contribution: 5    

RE: what is the use of temporary records and state record in application engine
Temp Tables:
The are used to store the immediate values during the processing of the AE.
They help in batch processing by creating multiple instances and there by facilitating parallel processing.
If used properly they can greatly improve the performance.
State Records:
They are used to pass on values from one section/step/prog to the other.
There can be a max of 200 state rec that can be used in a single AE but only one of them can be default.state record name must end with _AET.

 
Is this answer useful? Yes | No
December 13, 2007 07:22:02   #2  
sharry Member Since: July 2007   Contribution: 5    

RE: what is the use of temporary records and state record in application engine

For state record...


State record is used for providing the variables database fields to different sections of the application engine. Scope of the state record is limited to the application engine program. AE can have multiple state records but can have only one as a default state record.

It can be physical or derived work record. Physical record can be used when you have a restart logic and when you have disables the restart logic derived and work record can be used.

The naming convention is it must end with _AET identifier and process instance should be the one and the only key for the state record so that application will identify the record as a state record.


 
Is this answer useful? Yes | No
March 28, 2008 08:51:06   #3  
nsivudu Member Since: March 2008   Contribution: 11    

what is the use of temporary records and state record in application engine
Temporary table can be used in application engine programs to support parallel processing.

The state record will be used to pass variable information between two application engine sections
..........Sivananda Reddy...........

 
Is this answer useful? Yes | No
October 28, 2009 09:26:36   #4  
bandisdevi Member Since: April 2008   Contribution: 21    

RE: what is the use of temporary records and state record in application engine

Temporary table: To allow other users to access the same table that has been using by the AE program. These are mainly used in batch processing. These can store specific data to update without affecting the main application table. This is a database object. To increase the performance of AE program. Used to process data of tables having huge amounts of data in less time.

State record: We can use to pass variables between sections to section. Process instance is the mandatory field. We can insert the data into state record through select selectinit. We can retrieve the data from the state record through bind. The name of the state record must end with AET. When the AE program completes successfully the row of data in the state record is deleted.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape