COURSES UPDATE:
NEW JOB ORIENTED CAREER COURSES STARTING FROM 10th Aug 2019. ANY GRADUATE CAN DO THIS. GRAB THIS OPPORTUINITY NOW. WE WILL GIVE GUARANTEE OF YOUR JOB. | OTHER WEEKEND BATCH SCHEDULES |  HADOOP  (02:00:PM)  |    APPIUM And REST ASSURED  (05:00:PM)  |  AWS AND DEVOPS  (05:00:PM)  |  ADVANCED SELENIUM, JAVA AND DEVOPS PIPELINE  (04:00:PM)  |  ANGULAR 6  (10:00:AM)  |   LINUX SHELL SCRIPTING / ADMIN  (11:00:AM)  |  More Information Click Here..  
+91 7588262721 / 9665875790 / 9923488942 info@orilent.com / orilenttap@gmail.com


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.