ETL Process flow

During Extraction, the desired data is identified and extracted from many different sources,  including database systems and applications. Very often, it is not possible to identify the specific  subset of interest; therefore more data than necessary has to be extracted, so the identification of  the relevant data will be done at a later point in time. After extracting data, it has to be physically transported to an intermediate system for further processing. 

Depending on the chosen way of transportation, some transformations can be done during this  process, too. For example, a SQL statement which directly accesses a remote target through a  gateway can concatenate two columns as part of the SELECT statement. Based on the  requirements, some transformations may take place during the Transformation and Execution  Phase. Through Informatica mappings, the necessary changes and updates of the data are made  using transformations. 



Then in the Load phase the data is loaded in the target. After all the transformations, it has to be  physically transported to the target system for loading the data into the Target.

25 comments :

  1. I think this is actually a very nice information about Informatica and its related aspects.
    Informatica Read Rest API

    ReplyDelete
  2. I just have one question regarding ETL process flow. When you are following an ETL strategy for your business, what should be the first priority?
    1. Migrating data in the right way to the data warehouse?
    2. Validation that the right type of data is being moved?
    3. Goals of what stakeholders have in mind?
    4. Testing of a small data set so that everything works in the best possible way?

    ReplyDelete

  3. Great post i must say and thanks for the information.

    Data Scientist Course in pune

    ReplyDelete
  4. Thank you so much for exploring the best and right information about how useful is Informatica's set of tools and how one grasp the best out of it can.

    Informatica Read Rest API

    ReplyDelete
  5. It was to good to read on ETL Process. Thanks for sharing such contents.

    Data Science Training in Pune

    ReplyDelete
  6. I am really very happy to visit your blog. Directly I am found which I truly need. please visit our website for more information
    Web, Data Extraction Services

    ReplyDelete
  7. Nursing jobs in Qatar offer a dynamic and growing environment for healthcare professionals seeking new opportunities. With a robust healthcare system and increasing demand for skilled nursing staff, professionals can expect competitive salaries and attractive benefits. Nurses in Qatar often work in state-of-the-art medical facilities, providing care in various settings, including hospitals, clinics, and specialized centres. Many healthcare employers offer comprehensive training and support for international nurses to ensure a smooth transition into the local healthcare system. Additionally, Qatar’s tax-free salary structure can lead to significant financial advantages. The multicultural landscape provides a unique opportunity for personal growth and cultural exchange. Nurses can enjoy a high standard of living, with access to various recreational activities and amenities. Overall, nursing careers in Qatar are not only professionally rewarding but also offer a vibrant lifestyle.
    https://www.dynamichealthstaff.com/nursing-jobs-in-qatar

    ReplyDelete