How to Extract Data From Different Sources in PowerCenter Informatica

For ETL Testing Trainings Videos visit: https://www.etltestingtutorial.com/etl-testing-training

For ETL Testing Tutorial Free Videos Visit: https://www.etltestingtutorial.com/etl-testing-tutorial

Any file or table from where we can extract the data in Power Center Informatica is referred to as the Source. You can import or create the source definition.

Different formats can be used as source in Informatica, For eg: txt, CSV, XML, Excel files and Database Sources like : SQL, Oracle etc

When you import the source definition in Designer, we import only the metadata, that is column names, data type, size, indexes, constraints, dependencies, and so on. Actual data never comes with the Source structure in Designer. The data flows through the mapping in a row-wise manner when we execute the workflow in Workflow Manager.

Subscribe to Our Channel to get video updates. Hit the subscribe button above: https://bit.ly/30YnBoI

Facebook: https://www.facebook.com/whizdomtraining/
LinkedIn: https://www.linkedin.com/company/whizdom-training-s
Instagram: https://www.instagram.com/whizdomtrainings/

#infomatica #etltutorial #PowerCenterInformatica

Видео How to Extract Data From Different Sources in PowerCenter Informatica канала Ashish Thakur