what is Data Transformation Services (DTS) ?can u explain
me in detail?
Answer Posted / lakshmi
DTS is a kind of etl tool which extracts data from wide
range of sources like flatfiles,sql server,excel,oracle etc
and manipulating the data according to business logic by
using transformations before being loading into various
destinations.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are locks in sql?
What are the different types of join?
What do you know about normalization and de- normalization?
What is the federation in sql azure?
explain databases and sql server databases architecture? : Sql server database administration
Does any body please help me what question's have asked for SSRS in the interview?
How you can change a cross join into an inner join?
What happens if the update subquery returns no rows in ms sql server?
How do I connect to sql server database?
What is the process of normalization?
What is buffer cash in sql server?
What is the latest version of microsoft sql server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is a database in ms sql server?
How many types of functions are there in sql server?