- Variable used to store data.
- At a time you can store only one value.
- Variable value can be String,Number or Date.
- You can Pass this value at a run time
Where to use Variable
- In package
- In mapping
In this Example our source is Database table.
Step 1: Right click on Variable and Select new Variable
Step 2: Give proper name of variable and data type
Step 3: write query and validate it
Step 4: Create Target data store
Step 5: Give proper name and select data store type as table
Step 6: Define attribute for target data store
Step 7: Now we have source and target
Step 8: Create Mapping and
Just drag source and target into mapping area
Click on Join_date Attribute
Select on Expression to define variable expression
Step 9: Double click on hire_date variable
Step 10: Select integration knowledge module and
Step 11: See operator to view status
Step 12: right click and select data to view result
Step 13: you can see table data