Interested to Buy Any Domain ? << Click Here >> for more details...
What is DTS ?
- 1 Answers
- 5400 Views
- I also Faced
- E-Mail Answers
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 |
Where the applications and where
What is the 4 + 1 view model as it relates to system modeling?
What is a data profile?
In document how to create metrics?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
What is aggregate awareness?
Explain what are the modules in power mart?
What is load manager?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What are the various methods of getting incremental records or delta records from the source systems?
What are the differences between datamart vs. Reporting cube?
What are the different types of segments?
Teradata 
