We have a job that looks up from the same table that the job is loading into. Something like this.
Code: Select all
Table A
|
|
|
Hash File
|
|
SrcFile---->Transformer-------->Table A