Extract: This is the first step in the process of the ETL process in the Informatica tool which performs the process of obtaining data sets from the configured data source. This will then be loaded into the data warehouse. This process can also be called Capture.
Transform: The second step in the process of ETL is Transform which will be done from one format to another format which will be supported by the structure of the data warehouse that will be stored into.
Load: This is the third step in the ETL process which will perform the operations of storing the data into Database by creating indexes in the format of data warehouse structure after applying all the required transformations.
0 Comments