3/17/2024 0 Comments Sql extract transform load![]() Character set conversion : Need to transform the character sets as per the target systems.Standardizing data : Data is fetched from multiple sources so it needs to be standardized as per the target system. ![]() Real life examples of Data Transformation : There are following important steps of Data Transformation :ġ.Selection : Select data to load in targetĢ.Matching : Match the data with target systemģ.Data Transforming : We need to change data as per target table structures.Data has to be cleaned, mapped and transformed.We need to transform it before loading in to target server. Data Extracted from source system is in to Raw format.The data transformation is second step.After extracting the data there is big need to do the transformation as per the target system.I would like to give you some bullet points of Data Transformation. Source System Performance : The Extraction strategies should not affect source system performance. (Initial Load)Ģ.Partial Extraction : Sometimes we get notification from the source system to update specific date. There are 2 Types of Data Extractionġ.Full Extraction : All the data from source systems or operational systems gets extracted to staging area. The data extraction is first step of ETL. In this section i would like to give you the ETL Concepts with detailed description. These are some important terms to learn ETL Concepts. The Staging area is nothing but the database area where all processing of the data will be done. The Data mapping is nothing but the relationships between database objects. Target System is any system where we are loading the data. The source system is any system from which we are extracting the data.Įxample : It should be any database,Application,File with data. In this section i would like to give you some Important terms before i explain detail about ETL. Check for the tool which will provide facility of Data Quality. Data Quality : Check whether data is consistent and clean.Transformation Flexibility : Lot of complex transformation should be made with simple drag and drop in ETL Tools.By considering the data volume user needs to check the performance of ETL tool ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |