6 Informatica -- Joiner transformation.

preview_player
Показать описание
Selenium with Python:

Python:

Salesforce:

Data Warehousing and Data Mining:

Julia Tutorials:

Cloud Computing:

Machine Learning using WEKA:

Internet of Things:

Join Employee and Dept table using joiner transformation.
Opening VMware:
Step1: Creating folder
Step2: Creating Two source table (EMP,DEPT)
Step3: Create target table manually
Step4: Checking target table
Go to targets.
Click on generate and execute.
Step5: Creating mapping through joiner
Go to tools.
Select mapping designer.
Drag EMP and DEPT tableS to mapping designer.
Click on transformations.
Click on create.

Select condition tab
Click on add new condition icon
Select deptno in master and detail columns list

Select properties tab
Select normal Join as join type
Select OK Button
Step7: Create session
Step8: Passing instructions to session
Go to connections.
Click on relational
Step9: Creating workflows
Step8: Creating workflows
Select the tools.
Choose workflow designer.
Select workflow menu choose create.
Go to sql plus.
Рекомендации по теме