Describe how dts is used to extract, transform and consolidate data?
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 |
Explain the concepts and capabilities of data mining?
Tell me something about data mining? Where is it used? Can you tell its 3 applications?
What Is Model In Data Mining World?
What are advantages of data mining?
Explain Machine Learning Based Approach?
What Is Ods?
Explain mining single ?dimensional boolean associated rules from transactional databases?
Name methods of classification methods?
Name types of data mining?
List the types of OLAP server?
What Is Naive Bayes Algorithm?
Hierarchical clustering algorithm is known to be?
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)