Quiz 9 - Transformation

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

data splitting and aggregation

Data transformation involves duplication and load data splitting and aggregation format changes and load format changes and encryption

specified source database

Extract function in ETL reads data from specified source database unknown database data mart data warehouse

Competitions' data

In data extraction process for an ETL tool, which of the following is not an example of legit data source? Competitions' data Customers' social media data Point of Sales data Online Line Transaction data

Data Warehouse

In loading phase of an ETL tool, the transformed data gets loaded into an end target usually the _______. Data warehouse Original Database Master data management Online analytical processing

Load

One of the processes in ETL is Treatment Transition Extend Load

Load

The final stage of an ETL process is: Data Analysis Load Extract Transform

Teradata

Which of the following is an ETL vendor? Teradata JMP Tableau MySQL

data quality

Which of the following is not a requirement for an ETL architecture? data integration data compliance data quality data security

Data extraction from ERP

Which of the following is not a standard practice in "Data Transformation" process of an ETL tool? Splitting data fields Data extraction from ERP Data aggregation Change of data format

Encrypting

Which of the following is not one of the processes involved in data cleaning? Encrypting Consolidating Parsing Matching


संबंधित स्टडी सेट्स

Chapter 5 Annuities (10 Questions on Exam)

View Set

EXAM 4, Porth Patho Ch 37 & 38 Preview Quiz, Exam 3 Pt 2 (36-70), NUR 529 Exam 4 review, Adv Patho Quiz 12, Ch. 43 Disorders of skeletal system: trauma, infections, neoplasms, and childerhood disorders, Patho FINAL Prep U Chapter 43, PATHO CH 50, Cha...

View Set

Unit 8: Atomic Structure & Nuclear

View Set

Anatomy Exam 4: Functions of the brain and meninges

View Set

Medication Order Entry/ Fill Process MCQs

View Set

CSI101(4), CSI101(5), CSI101(8), CSI101(9), , csi101all

View Set

Ethical issues in business final exam

View Set