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?
- 5 Answers
- 14873 Views
- I also Faced
- E-Mail Answers
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
What is the purpose of the sqlexec function? What are its benefits and draw backs?
Explain the difference between temporary table and sql view in peoplesoft?
What is auto update?
What is getlevel0()?
What are the benefits of set control field in record field properties?
Explain what is html & image meta data?
What is the use of primary permission list in user profile?
Explain what is menu meta data?
How can you improve the security and usability of a prompt table edit?
What HTTP servers and Java servlet engine combinations are supported with PeopleTools 8.4?
What is maximum dimension of an array?
What are the differed processing advantages?
What is difference between field default and row init?
What types of audits are supported by people soft? In case of record level audit what is the structure of table?
How the output of a sql query be stored in a variable using peoplecode?
