InterviewSolution
| 1. |
Define Pass-through Sql? |
|
Answer» Pass-Through SQL lets you use native SQL without any of the restrictions the data SOURCE imposes on sub queries. You can ENTER any SQL SUPPORTED by the DATABASE. Disadvantages: There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source. Pass-Through SQL lets you use native SQL without any of the restrictions the data source imposes on sub queries. Advantages: You can enter any SQL supported by the database. Disadvantages: There is no opportunity for Frame work manager to automatically optimize performance. The SQL may not work on a different data source. |
|