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 an use case?
What are the main steps to build the data warehouse?
Where the data cube technology is used?
Whether dimension table can have numeric value?
Why denormalization is promoted in universe designing?
What is aggregate fact table?
What are the fundamental elements of the data warehouse?
What is called dimensional modelling?
What is Operational Data Store?
How can we schedule the graph in unix?
What is a functional dependency f said to be minimal?
What are the various methods of getting incremental records or delta records from the source systems?
What is fact less fact table? Where you have used it in your project?
Explain difference between snow flake and star schema.
Explain grouped cross tab?