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
Explain what is file layout definitions?
Explain what is portal (structure and content)?
What is portal (structure and content)?
Explain what is process scheduler information?
What is field meta data?
Explain tree manager?
Situation: you want to connect report through process scheduler. How would you do that?
You want to migrate database from one database to another. How would you do that?
Is WebSphere certified on PeopleTools 8.1x?
What is user profile & security?
What is change control?
What is difference between getrowset and createrowset in people code?
What is getlevel0()? What is the use of %subrec and %selectall functions?
What is xlat - translate values?
How to store related field data into database?