How to get source file name to store in table column

I have a requirement to get the source file name and store the same in target database table column. Please let me know how to achieve the same.

Advanced User Asked on December 3, 2020 in Diyotta Studio.
Add Comment
2 Answer(s)

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.

RE: How to get source file name to store in table column

Expert Answered on December 8, 2020.
Add Comment

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.

RE: How to get source file name to store in table column

Advanced User Answered on December 8, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.