Answer Posted / 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 |
Post New Answer View All Answers
What is data analysis?
List any five applications of data warehouse.
What is surrogate key? Explain with examples.
What is called dimensional modelling?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is a core dimension?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
How can you clear the cache?
How can we do data cleaning?
What is dimension modeling?
What is the purpose of cluster analysis in data warehousing?
Is there any rownum object from which we can do this?
What is drilling across?
What are the reasons to use a chameleon method in data warehousing?
What is a fact, dimension, measure?