Describe the relationship of OLE DB-ADO-ODBC
Describe the relationship of OLE DB, ADO, and ODBC?
Expert
Developed first, the ODBC standard is for relational databases; whereas the OLE DB standard provides functionality for both relational and other databases. Finally, ADO was developed to provide simpler access to OLE DB data for the non-object-oriented programmer.
Explain the term optimization and performance tuning and its work in practical projects?
Explain the following term: a) ROLAP b) MOLAP
What demerits of ODBC does OLE DB overcome?
Can we have a report with several data providers?
What are the purposes of using lookups?
Describe in brief some of the criticism regarding Sybase IQ?
Specify the various types of Aggregation?
Provide a brief introduction of the term ‘junk dimension’?
State various types of the input links within the data stage?
What is meant by the term merge?
18,76,764
1955779 Asked
3,689
Active Tutors
1427727
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!