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 method is used by the Command classes to execute SQL statements that return single values?
What are the main differences between #temp tables and @table variables and which one is preferred?
What are the dis_advantages of stored procedures, triggers, indexes?
Explain why variables called the most powerful component of ssis?
What is de-normalization and what are some of the examples of it?
What Is Rdbms?
How can sql server instances be hidden? : sql server security
What causes index fragmentation?
Which are the olap features?
How to configure and test odbc dsn settings?
What are tables in sql server?
What is mean by dml?
how you can configure a running aggregate in SSRS?
How to disable stored procedure sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration