Thursday, November 9, 2017

What is ETL?

qWhat is ETL?
vStands for Extract Transform Load. It Extracts data from multiple data sources ,transform( filter, aggregate, etc) according to the business rules and then load it into target(ODS/DWH).

vETL Tools: Informatica Power Center ,Data stage, Oracle Warehouse Builder, SQL Server Integration Services, Data Migrator(IBI)


No comments:

Post a Comment

ER Modeling vs Dimensional Modeling