What is DTS ?
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 |
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
What is IQD file?
What is freehand sql?
What is Active Datawarehousing?
Explain what is difference between query studio and report studio?
What are the primary ways to store data in OLAP?
What is the "junk dimension"? Give with examples?
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
Can you state some of the innovations throughout history?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is meant by metadata in context of a data warehouse?
Explain the hierarchies level data warehousing.