RE: 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.

JohnGS Advanced User Asked on December 3, 2020 in Diyotta Studio.
Add Comment
2 Answers

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

Your Answer

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