What is DTS ?
- 1 Answers
- 5065 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 |
Explain what is the difference between view filter and report filter?
After the complete generation of a report who will test the report and who will analyze it?
What are the tools available for etl?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain Process flow in data warehouse??
What is surrogate key? Where we use it explain with example?
How can you implement many relations in star schema model?
Explain a mapping, session, worklet, workflow, mapplet?
What are the different problems that ?Data mining? can solve?
What is analytical or analytic mean?
Explain me what is vldb?
What is vldb(very large databases)?
Teradata 
