How to get source file name to store in table column
we have a list of system variables present at each jobflow/dataflow level .
Out of the system parameters we use the ”$$SrcFileName” present in the dataflow level parameters list, which will populate the source file name. this parameter can be added to an expression transformation attribute. The same attribute can be mapped into the target attribute.
This would populate the filename present in the extraction properties and load it into the target table column.
we can change the agents present at the datapoint level as shown below
1. select the datapoint which you want to change the agent.
2. In the datapoint move to the properties tab.
3. At the bottom of the Properties page you can find the Agent.
4. Then click on the change text and select the other agent from the agent list shown in the pop up.