Describe how dts is used to extract, transform and consolidate data?
Answer Posted / Naresh Pal Singh
Data Transformation Services (DTS) in SQL Server is used for ETL (Extract, Transform, Load) operations. It allows you to extract data from various sources like databases, files, and other applications; transform the extracted data using a variety of tools like SQL queries, scripts, or lookup tables; and consolidate or load the transformed data into a destination like a database table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category