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 are templates in which way it is help full?
What is pre-emptive and non-pre-emptive?
What are fact, dimension, and measure?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Compare and contrast aggregates & indexes
What are the different methods of loading dimension tables?
Explain which are the olap tools available that are supported by oracle?
What is static and local variable?
What are the steps to build the datawarehouse?
if you use oracle sql*loader , how do you transform data with it during loading?
What is "method/1"?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
List any five applications of data warehouse.
What are loops in Datawarehousing?