Interested to Buy Any Domain ? << Click Here >> for more details...
What is DTS ?
- 1 Answers
- 5497 Views
- I also Faced
- E-Mail Answers
Answer / azhar
DTS stands for Data Transfer Services. It was introduced in
sql server 7.0.
In sql server 2000 DTS was a bit advanced by adding
scripting like VB Scripting. Previously DTS was a wizard
kind of thing so now DBA's were finding it difficult to
write the scripts which was easily done by developers.In
2005 it came as Integration Service.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the other names given to data warehousing?
What is core dimension?
Explain what are the basic needs to join two sources in a source qualifier?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Database in use is oracle?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
Ist the schema that a data warehouse system can implements.
what is query optimizer? what are different types of optimizer s supported by oracle ?
How much data hold in one universe.
What is surrogate key?
What is the extension of file to save template?
Teradata 
