Explain the difference between Translate & Prompt tables.
What are the occasions when to use Translate values instead
of Prompt table? What is the advantage of one over the other?
Answer Posted / write2gg
The Translate table option houses strings of length < 5.
The translate table values are readily available reducing
the trip to db everytime .
The transalte table values are faster in performance.
The translate table option is used when # of options is less
The Prompt Table values houses strings of any lenght < 255.
The prompt table values can also bring other related
information to the page.
The prompt table values are fetched by making a trip to DB
everytime.
The prompt table values are useful for multi-lingual setup.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can you hide a primary page in a component? Reason?
What is file layout definitions?
What is differed processing?
What are the differed processing advantages?
Tell me what will be the output of an application engine to use component variables instead of state record?
Why do peoplesoft often use views as search records?
What is the use of temporary records and state record in application engine?
What is an array in people code?
What types of audits are supported by people soft?
How to store related field data into database?
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?
What is difference between saveprechange and savepostchange?
Can a PeopleTools 8.4 and a PeopleTools 8.1x application server run on the same machine?
What is sql definitions?
What is difference between getrowset and createrowset in people code?