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 |
Explain what are the basic needs to join two sources in a source qualifier?
How can you set the session management?
What is the difference between static cache and dynamic cache?
Explain in simple terms, the concept of Data Mining.
What are data modeling and data mining?
What are the different types of scd's used in data warehousing?
How to performance tune reports?
What are cluster analysis in data warehousing?
What is incremintal loading?
What are the stages of datawarehousing?
What are data validation strategies for data mart validation after loading process?
When should you use a STAR and when a SNOW-FLAKE schema?