what is ETL? ETL is a process that extracts the data from different source systems, then transforms the data (like applying calculations, concatenations, etc.), and finally loads the data into the Data Warehouse system. The full form of ETL is Extract, Transform, and Load. What is a data warehouse (DW)? A Data Warehouse (DW) is […]
Posts Tagged ‘Cloud ETL’
SCD Type 1 using tAddCRCRow component
When we approach a scenario related to database, commonly used SCD types. Even though Talend has an inbuilt component we mostly prefer not to use tDBSCD feature to improve performance. The common way to implement SCD is to normalize a job design instead of using a single component. Irrespective of technology people look for an […]
Oracle BI Cloud – Quick Demo of Different Data Loading Methods
The Oracle Business Intelligence Cloud Service (BICS) offers various options through which data may be loaded into the BI cloud database. I am focusing here on BICS that comes with the Database Schema service as a reporting database. In addition, there are several ways through which you may extract data from BICS. It may be […]
Oracle BI Cloud Service: Data Sync Released & DBaaS Supported
Today Oracle releases Data Sync, a tool that facilitates loading data into the Oracle BI Cloud Service (BICS) by offering a variety of capabilities: Loading data from on-premise relational databases or data files into BICS Schema Database Scheduling data load jobs Monitoring data load jobs Sending out email notifications Earlier this week, Oracle has upgraded […]