Talend DI (Data Integration)

Get course
Talend DI

Talend DI (Data Integration)

Download Course Content

Chapter 1:

1
Data integration and Talend Studio:
2
Data analytics
3
Operational integration
4
Execution monitoring

Chapter 2:

1
Getting started with Talend Studio:
2
Important concepts in Talend Open Studio for Data Integration
3
Launching Talend Open Studio for Data Integration
4
How to launch the Studio for the first time
5
How to set up a project
6
Working with different workspace directories
7
How to create a new workspace directory
8
Working with projects
9
How to create a project
10
How to import the demo project
11
How to import projects
12
How to open a project
13
How to delete a project
14
How to export a project
15
Migration tasks
16
Setting Talend Open Studio for Data Integration preferences
17
Java Interpreter path
18
External or User components
19
Exchange preferences
20
Language preferences
21
Debug and Job execution preferences
22
Designer preferences
23
Adding code by default
24
Performance preferences
25
Documentation preferences
26
Displaying special characters for schema columns
27
SQL Builder preferences
28
Schema preferences
29
Libraries preferences
30
Type conversion
31
Usage Data Collector preferences
32
Customizing project settings
33
Palette Settings
34
Version management
35
Status management
36
Job Settings
37
Stats & Logs
38
Context settings
39
Project Settings use
40
Status settings
41
Security settings

Chapter 3:

1
Designing a Business Model:
2
What is a Business Model
3
Opening or creating a Business Model
4
How to open a Business Model
5
How to create a Business Model
6
Modeling a Business Model
7
Shapes
8
Connecting shapes
9
How to comment and arrange a model
10
Business Models
11
Assigning repository elements to a Business Model
12
Editing a Business Model
13
How to rename a Business Model
14
How to copy and paste a Business Model
15
How to move a Business Model
16
How to delete a Business Model
17
Saving a Business Model

Chapter 4:

1
Designing a data integration Job:
2
What is a Job design
3
Getting started with a basic Job design
4
How to create a Job
5
How to drop components to the workspace
6
How to search components in the Palette
7
How to connect components together
8
How to drop components in the middle of a Row link
9
How to define component properties
10
How to run a Job
11
How to customize your workspace
12
Using connections
13
Connection types
14
How to define connection settings
15
Using the Metadata Manager
16
How to centralize the Metadata items
17
How to centralize contexts and variables
18
How to use the SQL Templates
19
Handling Jobs: advanced subjects
20
How to map data flows
21
How to create queries using the SQLBuilder
22
How to download/ upload Talend Community components
23
How to install external modules
24
How to launch a Job periodically
25
How to use the tPrejob and tPostjob components
26
How to use the Use Output Stream feature
27
Handling Jobs: miscellaneous subjects
28
How to share a database connection
29
How to define the Start component
30
How to handle error icons on components or Jobs
31
How to add notes to a Job design
32
How to display the code or the outline of your Job
33
How to manage the subjob display
34
How to define options on the Job view
35
How to find components in Jobs
36
How to set default values in the schema of an component

Chapter 5:

1
Managing data integration Jobs:
2
Activating/Deactivating a Job or a sub-job
3
How to disable a Start component
4
How to disable a nonStart component
5
Importing/exporting items or Jobs
6
How to import items
7
How to export Jobs to an archive
8
How to export items
9
How to change context parameters in Jobs
10
Managing repository items
11
How to handle updates in repository items
12
Searching a Job in the repository
13
Managing Job versions
14
Documenting a Job
15
How to generate HTML documentation
16
How to update the documentation on the spot
17
Handling Job execution
18
How to deploy a Job on SpagoBI server

Chapter 6:

1
Mapping data flows:
2
tMap and tXMLMap interfaces
3
tMap operation
4
Setting the input flow in the Map Editor
5
Mapping variables
6
Using the expression editor
7
Mapping the Output setting Talend Open Studio
8
Setting schemas in the Map Editor
9
Solving memory limitation issues in tMap use
10
Handling Lookups
11
tXMLMap operation
12
Using the document type to create the XML tree
13
Defining the output mode
14
Editing the XML tree schema

Chapter 7:

1
Managing Metadata:
2
Objectives

Setting up a DB connection:

1
Step 1: General properties
2
Step 2: Connection
3
Step 3: Table upload
4
Step 4: Schema definition

Setting up a JDBC schema:

1
Step 1: General properties
2
Step 2: Connection
3
Step 3: Table upload
4
Step 4: Schema definition

Setting up a SAS connection Prerequisites:

1
Step 1: General properties
2
Step 2: Connection

Setting up a File Delimited schema:

1
Step 1: General properties
2
Step 2: File upload
3
Step 3: Schema definition
4
Step 4: Final schema

Setting up a File Positional schema:

1
Step 1: General properties
2
Step 2: Connection and file upload
3
Step 3: Schema refining
4
Step 4: Finalizing the end schema

Setting up a File Regex schema:

1
Step 1: General properties
2
Step 2: File upload
3
Step 3: Schema definition
4
Step 4: Finalizing the end schema

Setting up an XML file schema:

Setting up an XML schema for an input file:

Setting up an XML schema for an output file:

Setting up a File Excel schema:

1
Step 1: General properties
2
Step 2: File upload
3
Step 3: Schema refining
4
Step 4: Finalizing the end schema

Setting up a File LDIF schema:

1
Step 1: General properties
2
Step 2: File upload
3
Step 3: Schema definition
4
Step 4: Finalizing the end schema

Setting up an LDAP schema:

1
Step 1: General properties
2
Step 2: Server connection
3
Step 3: Authentication and DN fetching
4
Step 4: Schema definition
5
Step 5: Finalizing the end schema

Setting up a Salesforce connection:

1
Step 1: General properties
2
Step 2: Connection to a Salesforce account
3
Step 3: Retrieving Salesforce modules
4
Step 4: Retrieving Salesforce schemas
5
Step 5: Finalizing the end schema

Setting up a Generic schema:

1
Step 1: General properties
2
Step 2: Schema definition

Setting up an MDM connection:

1
Step 1: Setting up the connection
2
Step 2: Defining MDM schema

Setting up a Web Service schema:

Setting up a simple schema:

Setting up an FTP connection:

1
Step 1: General properties
2
Step 2: Connection

Chapter 8:

Exporting Metadata as context:

Managing routines:

1
What are routines ?
2
Accessing the System Routines
3
Customizing the system routines
4
Managing user routines
5
How to create user routines
6
How to edit user routines
7
How to edit user routine libraries
8
Calling a routine from a Job
9
Use case: Creating a file for the current date

Chapter 9:

Using SQL templates:

1
What is ELT
2
Introducing Talend SQL templates
3
Managing Talend SQL templates
4
Types of system SQL templates
5
How to access a system SQL template
6
How to create userdefined SQL templates
7
A use case of system SQL Templates

Chapter 10:

1
Datawarehousing Concepts
2
ETL Concepts
3
tsortrow
4
tunite
5
tuniqerow
6
tbufferinput
7
tbuffer output
8
thashinput
9
thashoutput
10
tfilelist
11
tsleep
12
tloop
13
file input output components
14
database input output components
15
tsendmail
16
treplicate
17
tfiltercolumns
18
tfilterrows
19
treplace
20
tconverttype
21
tdie
22
tcontextload
23
tmemorizerow
24
trowgenerator
25
trunjob
26
prejob
27
postjob
28
tsamplerows
29
tnormalize
30
tdenormalize
31
tmap
32
taggrigator
33
tjoin
34
tsystem
35
Dynamic
36
tjava
37
tjavarow
38
tjavaflex
39
tschemacompliancecheck
40
tlogrow
41
tlogcatcher
42
t ststcatcher
43
tparallelize
44
tsendmail
45
tfilecopy
46
tfilearchive
47
tfileProperties
48
tfileunarchive
49
tfiletouch
50
tfiledelete
51
tfileexist
52
tfiletouch
53
tfilecopy
54
tftpfilelist
55
tftpput
56
tftpget
57
tftpdelete
58
tftpfileexist
59
tftpConnection
60
tftpRename
61
tftpfileproperties
62
toracleInput
63
toraclerow
64
toracleoutpt
65
toracleconnection
66
toracleBulk
67
toracleBulkexec
68
toracleClose
69
toracleRollback
70
toraclecommit
71
tmssqlInput
72
tmssqlrow
73
tmssqloutpt
74
tmssqlconnection
75
tmssqlBulk
76
tmssqlBulkexec
77
tmssqlClose
78
tmssqlRollback
79
tmssqlcommit
80
tDb2Input
81
tDb2row
82
tDb2outpt
83
tDb2connection
84
tDb2Bulk
85
tDb2Bulkexec
86
tDb2Close
87
tDb2Rollback
88
tDb2commit
89
OnsubJobOK
90
OnSubjobError
91
OnComponentOk
92
OnComponentError
93
runif
94
tExcelInput
95
tExceloutput
96
tfileInputdelimited
97
tfileoutputDelimited
98
tfileInputXml
99
tfileoutputXml
100
tfileinputPositional
101
tfileOutputPositional
102
SCD1
103
SCD2
104
SCD3
105
stage loading
106
Dimension Loading
107
fact Loading
108
project Explanation

Be the first to add a review.

Please, login to leave a review
Price:
INR. 20,000 INR. 14,000