Describe how dts is used to extract, transform and consolidate data?
- 1 Answers
- 136 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What Is Ods?
What is spatial data mining?
What is Syntax for Specifying the Kind of Knowledge?
What is required technological drivers in data mining?
What are the cons of data mining?
Define wave cluster?
Define chameleon method?
What snow flake schema?
Explain mining single ?dimensional boolean associated rules from transactional databases?
What are major elements of data mining, explain?
Differences between star and snowflake schemas?
Explain steps involved in data mining knowledge process?
-
AI Algorithms (74) - AI Natural Language Processing (96)
- AI Knowledge Representation Reasoning (12)
- AI Robotics (183)
- AI Computer Vision (13)
- AI Neural Networks (66)
- AI Fuzzy Logic (31)
- AI Games (8)
- AI Languages (141)
- AI Tools (11)
- AI Machine Learning (659)
- Data Science (671)
- Data Mining (120)
- AI Deep Learning (111)
- Generative AI (153)
- AI Frameworks Libraries (197)
- AI Ethics Safety (100)
- AI Applications (427)
- AI General (197)
- AI AllOther (6)
