Interested to Buy Any Domain ? << Click Here >> for more details...
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 cleaning? How can we do that?
What is the 4 + 1 view model as it relates to system modeling?
What is meta data and system catalog?
What is is a star schema?
Why we use repository connectivity?
What is a relationship?
What are the steps involved in creating dimensional modeling process?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is metadata in context of a datawarehouse?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
explain about balanced dimension,
Store (and count) non-fact records?
What should I have in mind when building olap solution from scratch?
