Lesson 1: Data Modeling Concepts
o Understanding the basics of Data Modeling
o its significance and how to deploy Data Modeling in Data Warehouse environment.
Lesson 2: Deep Dive into Data Modeling
o The various types of Data Modeling, learning to perform Conceptual Data Modeling
o Physical Data Modeling, Logical Data Modeling
o understanding the scope and benefits of Data Modeling.
Lesson 3: Multidimensional Data Modeling
o The basic Architecture of multidimensional modeling
o deploying Cubes to perform multidimensional modeling
o understanding the concepts of Facts and Dimensions and the differences between the two.
Lesson 4: Introduction to Talend
o The Talend Open Source data integration tool
o working with Big Data
o understanding the Talend Open Studio.
Lesson 5: Talend Installation
o Understanding the installation of Talend, system requirements
o troubleshooting of common errors and issues related to installation.
Lesson 6: Talend Key Features
o Learning about the Talend Architecture, important concepts and features
o Talend components like Job, Workspace, Metadata, Project, etc.
Lesson 7: Talend Job Creation, Data Management Techniques
o Learning to create a Talend Job
o working with Delimited file, working with Meta Data
o schema for data integration
o understanding Propagation
o deploying of tFilterRow and string filter for creating Jobs
o creation of CSV file.
o Deploying Talend Open Studio for Data Management, data quality, integration
o understanding the ETL and Data Warehousing concepts.
Lesson 8: Schema & Data Aggregation, DataSource Connection
o Detailed understanding of Talend Job design, it features, learning about tMap, data aggregation techniques, tReplicate for performing different operations on a Schema
o tMap for mapping input and output data.
o Working with DataSource Connection
o deploying in database component
o creating a connection
o database source and target
o metadata and schema importing.
Lesson 9: Talend Routines/Functions, Data Transformation
o Introduction to Talend Functions, calling and deploying the Functions
o understanding Routines, Talend Open Studio for XML data processing, date format function.
o Transforming Data, Running the Job
o Combining Columns
o Duplicating a Job.
Lesson 10: Working with Metadata, Data Corrections
o Creating Metadata, Joining Data Sources.
o Capturing Rejects
o Correcting the Lookup, Duplicating a Job
Lesson 11: Data Filtering, Context Variables, Graphical Interface of Talend, Trigger
o Filtering Output Data, Using Multiple Filters.
o Using Context Variables from Talend Job, Repository as Metadata.
o Building Jobs, Graphical Jobs, Graphical Interface Of Talend, Talend’s Components Naming Convention
Lesson 12: File Management
o File Management in Talend
o Connecting Talend with Hadoop
o Deploying Talend to work with Hadoop, defining the ETL method, Hive implementation with Talend, importing data in Hive, Hive partitioning, Pig in Talend, data loading and parallel data execution.