Describe the ETL Process.

E stands for Extract, T for Transform and L for Load. It refers to a trio of processes that are needed to understand the information from its supply to an information warehouse that is to a business intelligence system or a large knowledge platform.

• Extract: This step involves accessing the info from all the Storage Systems like RDBMS, stand out files, XML files, flat files etc.
• Transform: In this step, entire knowledge is analyzed, and numerous functional area units are applied on to remodel the job into the desired format.
• Load: In this step, the processed knowledge, i.e., the extracted and renovated knowledge is then loaded to a target knowledge repository that typically is the information. It can be utilizing the bottom resources.