InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain The Usage Of Settransobject Function With Composite Dws? |
|
Answer» Only this FUNCTION should be used for composite presentation styles acting as containers for other DW objects. If SETTRANS () is used with each DW in a composite DW then disconnect does not occur until PB session ends. It should be used only for pure RETRIEVAL when DB locks need not be held on tables in other words update () functions are not used. Only this function should be used for composite presentation styles acting as containers for other DW objects. If settrans () is used with each DW in a composite DW then disconnect does not occur until PB session ends. It should be used only for pure retrieval when DB locks need not be held on tables in other words update () functions are not used. |
|