1.
Extract: Extracting
the data from various sources
2. Load:
Loading the data into the destination target
3.
Transform: Transforming
the data according to a set of business
rules
Data is one of the most important assets
of any company, and data integration constitutes the backbone of any enterprise’s IT systems.
Choosing
the technology for data integration is critical for productivity and
responsiveness of business divisions within an enterprise.
ELT stands for extract, load, and
transform. It includes the processes that enable companies to move data from multiple sources,
reformat and cleanse the data, and load it into another
database, or a data warehouse for
analysis, to support a business process.
ODI provides a strong and reliable
integration platform for IT infrastructure.
Built on the next-generation architecture of extract, load,
and transform (ELT), ODI delivers superiorperformance and scalability connecting
heterogeneous systems at a lower cost thantraditional, proprietary ETL products.
Unlike conventional extract, transform, and load (ETL)design, with ODI, ELT architecture
extracts data from sources, loads it into a target, and transforms it by using the database power
according to business rules.
The tool automatically generates
data
flows, manages their complexity, and administers the correct instructions for the various
source and target systems.
No comments:
Post a Comment