INTERVIEW QUESTIONS
SIEBEL
SIEBEL REALTIME
DETAILS
Question: Explain when we use the following scenario's:
Base table having extension columns
Extension table have extension columns
Which one do you prefer, Explain?
Answer: In Siebel 7.8 there is no restriction in the number of columns in tables, but depending on the frequency of use and the relationship you should use it discretely (when 1:1 relation is there).
|
Question:
Explain when we use the following scenario's:
Base table having extension columns
Extension table have extension columns
Which one do you prefer, Explain?
Answer:
In Siebel 7.8 there is no restriction in the number of columns in tables, but depending on the frequency of use and the relationship you should use it discretely (when 1:1 relation is there).
Source: CoolInterview.com
Its better to extent the base table rather than the extenstion table. As per the Siebel best parctice we are supposed to extent the base table only if the required type columns are not persent in the extension table. Source: CoolInterview.com
Answered by: jose | Date:
| Contact jose
When adding a new column: If column is not often populated, use an existing column in an extension table if available If field often populated, avoid join overhead by using adding an extension column to base table If data for column appears in: A form applet, prefer an existing column in an extension table A list applet, prefer an extension column in the base table Join overhead can be significant when displaying many records Source: CoolInterview.com
Answered by: Chandrani | Date: 3/28/2010
| Contact Chandrani
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|