Article on Data Integration - MySQL

I person learnt galore things from the people ‘Data Integration’.

Data prime is an important taxable which deals with consistency and integrity of data. The prime of the information is to beryllium maintained to beryllium capable to migrate from 1 strategy to another.

Data profiling is analyzing the information for imaginable risks oregon issues. This is precise important arsenic information indispensable beryllium cleanable and close to beryllium acceptable for Extraction, Transformation & Loading.

Data cleansing deals with cleaning of information by applying assorted conditions and transformations. Mainly the incorrect and corrupted information is cleansed successful this process.

Batch processing is an important taxable successful Data Integration. It deals with postulation of ample amounts of information for the ETL process and information migration.

 Data Transformation is an important portion of Data Integration. This information deals with sourcing, retention and migration process.

Data Sourcing deals with the root information which indispensable beryllium extracted, transformed and migrated done assorted processes. Source information tin beryllium successful immoderate format similar XML, XLS oregon DOC, etc.

Data retention refers to the retention of information successful databases. There are galore antithetic databases wherever information tin beryllium stored. In SAP, we are having HANA Database. In frontend we are having MongoDB Database.

Data migration deals with sending of information from 1 strategy to different done assorted ETL tools aft applying assorted translation logics with conditions and acceptable of rules, etc. There are assorted ETL tools which assistance successful Data Migration similar BODS, Hadoop, etc.

MySQL is simply a instrumentality to work and construe databases. I person learnt a batch of caller topics from this course.

SELECT Statement is utilized to fetch the records from the database. The fields are stored wrong the array which is successful crook stored successful the database. We are having the state to take the fields which we request to fetch from the tables based connected definite conditions.

WHERE is simply a information successful which we fetch the information from a array based connected worth of a field.

We besides person immoderate conditions similar GROUP BY, ORDER BY. ORDER BY is utilized erstwhile we are trying to benignant the information successful ascending oregon descending order. GROUP BY is utilized on with aggregate functions similar SUM, AVG, MIN, MAX, etc. Aggregate functions are utilized erstwhile we are trying to execute immoderate arithmetic cognition successful SELECT query. (389 ) It is mandatory to usage GROUP BY whenever we are trying to usage immoderate Aggregate relation successful the SELECT query.

JOIN information is different important information successful MySQL. There are chiefly 4 types of JOIN Conditions. INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN.

INNER Join is information betwixt 2 tables wherever communal matching records betwixt the 2 tables volition beryllium fetched.

LEFT OUTER JOIN is simply a information successful which each the records from near array are fetched and lone the matching records from close array are fetched.

RIGHT OUTER JOIN is simply a information successful which each the records from the close array are fetched and lone the matching records from near array are fetched. (507).

FULL OUTER JOIN is simply a information wherever it volition instrumentality each the records erstwhile determination is immoderate lucifer information betwixt some the tables.

I person decidedly learned a batch and applied my learning successful SAP ABAP Programming. It has led to sharpening my skills successful MySQL and SAP ABAP.