GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PeopleTools
Go To First  |  Previous Question  |  
 PeopleTools  |  Question 39 of 39    Print  
Temporary table and SQL view in peoplesoft
difference between temporary table and sql view in peoplesoft


  
Total Answers and Comments: 1 Last Update: August 13, 2008     Asked by: Priya21 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 13, 2008 02:22:16   #1  
ravi.velchuri38 Member Since: August 2008   Contribution: 2    

RE: Temporary table and SQL view in peoplesoft
Temporary Table: Temporary tables are used for running PeopleSoft Application Engine batch processes. Temporary tables can store specific data to update without risking the main application table.


SQL View: It is not a physical SQL table in the database but rather fields from one or more SQL tables that are reorganized into a different sequence. This provides an alternate view of information that is stored in tables.

 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    

 Related Questions

The PeopleSoft Internet Architecture uses a web application server and anHTTP server. PeopleTools 8.12 and above include both BEA WebLogic andApache with Jserv. With PeopleTools 8.4, both BEA WebLogic 

No. The PeopleSoft Mobile Agent architecture, which is used to supportdisconnected mobile applications, is only available in PeopleTools 8.4. ThePeopleSoft Mobile Agent is dependent upon certain core technologies 

Application Messaging is used by PeopleSoft applications to communicate withone another. This is true not just for 8.1x and 8.4 applications, but also betweenan 8.1x and an 8.4 application. For example, 
Latest Answer : Yes. ...

There are several scenarios that may exist when customers use the PeopleSoftEnterprise Portal with a mixture of 8.1x and 8.4 applications. Specificinformation on the use of the PeopleSoft Enterprise Portal 

All popular http servers (reverse proxies) are supported. Please refer to the platforms database onCustomer Connection for specific information on current certified platforms. You may find this athttp://www.peoplesoft.com/corp/en/iou/platforms/index.asp 
Latest Answer : Web logic and IBM Web server ...

Will the PeopleSoft Internet Architecture, now that it embeds BEA WebLogic and IBM web sphere, work with my other corporate web servers and tools?
One of the core values of the PeopleTools development group is investment protection. The time,money and resources that you may have already invested in licensing another web server, trainingdevelopers 

Yes. WebSphere or WebLogic are used as the HTTP server and servlet engine. They are not usedas middleware with the PeopleSoft Application Server. Tuxedo is always used with PIA,regardless of the HTTP server 

For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?
The PIA Java servlets in PeopleTools 8.4 are coded to JavaSoft's Java Servlet API 2.0 and arefully compatible with Servlet API 2.2. It should be noted that the PeopleSoft Internet Architectureis supported 

Both BEA WebLogic and IBM WebSphere have the ability to plug in to many different web servers. Does PeopleSoft support the web servers that they plug into
BEA and IBM provide plug-ins for many of the leading web servers. This allows the customer touse their own HTTP web server and WebLogic’s or WebSphere’s Java servlet engine. PeopleSoftuses 

Apache JServ was a servlet engine that was supported in PeopleTools 8.1x. This support has beenremoved from PeopleTools 8.4 for several reasons:v JServ is no longer an active product and is in maintenance 


 Sponsored Links

 
Related Articles

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

jQuery Table Row Finished Code

jQuery Table Row Finished Code The Finished Code Our second example page has demonstrated table row striping highlighting tooltips collapsing expanding and filtering Taken together the JavaScript code for this page is mosgoogle geshibot lang php" document ready function var highlighted
 

jQuery Expanding and Collapsing Table Rows

jQuery Expanding and Collapsing Table Rows The expanding and collapsing behavior added earlier also conflicts with our filters If a section is collapsed and a new filter is chosen then the matching items are displayed even if in the collapsed section Conversely if the table is filtered and a section
 

jQuery Table Row Filtering

jQuery Table Row Filtering Earlier we examined sorting and paging as techniques for helping users focus on relevant portions of a table s data We saw that both could be implemented either with server side technology or with JavaScript Filtering completes this arsenal of data arrangement strategies B
 

jQuery Collapsing and Expanding Table Rows

jQuery Collapsing and Expanding Table Rows When large sets of data are grouped in tables as each year s set of articles are in our News page collapsing or hiding a section s contents can be a convenient way to get a broad view of all of the table s data without having to scroll so much mosgoogle To
 

jQuery Table Manipulation

Learning jQuery Table Manipulation By Karl Swedberg Jonathan Chaffer Better Interaction Design and Web Development with Simple JavaScript Techniques Learning jQuery packtpub com jQuery book Table Manipulation Let em wear gaudy colors Or avoid display Devo Wiggly World" In the first si
 

What is a view

A view is nothing but a window of an existing table by which one can view and can also change the values in tables. The main point aspect of view is views have no storage space. For this reason views are also called as virtual tables. Thus in other words a view is a database object that gives a logi
 

SQL Table Commands

SQL Table Commands Overview As mentioned previously in this series of SQL articles, databases are primarily composed of tables. The “columns and rows” structure of the table allows data to be efficiently inserted, manipulated, updated, and deleted from the database. The three mos
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

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