9 Informatica -- Sequence Generator Transformation

Опубликовано: 10 Декабрь 2020
на канале: UMAMAHESWARARAO BATTA, Ph. D
632
6

Selenium with Python:
   • Selenium with Python  

Python:
   • Python  

Salesforce:
   • Salesforce  

Data Warehousing and Data Mining:
   • Data Warehousing and Data Mining  

Julia Tutorials:
   • Julia  programming Tutorials  

Cloud Computing:
   • Cloud Computing  

Machine Learning using WEKA:
   • Machine Learning using WEKA  

Internet of Things:
   • Internet of Things  


Opening VMware:
Step1: Creating folder
Step2: Creating source table (EMP)
Step3: Create target table manually(emp+seqno)
Step4: Checking target table
Go to targets.
Click on generate and execute.
5 Creating mapping through using Sequence Generator
Link the NEXTVAL column of sequence generator to SNO column in target
 link the other columns from source qualifier transformation to the target table
Double click on the sequence generator
Select the properties tab
Enter the properties with Start value =1, leave the rest properties as default
Select OK button
Step7: Create session
Step8: Passing instructions to session
Go to connections.
Click on relational
Step9: Creating workflows