Pls help on this issue.
I have a process, in which the target file is the lookup itself.
The workflow execution is successful and the target file gets updated after each execution.
But sometimes what happens is ,after execution the target file becomes empty.This issue is showing an inconsistent behaviour and I am not able to pin point the issue.
Can anyone help on this?
Thanks in advance..
Could you clarify the following questions -
a) Is the target a file/table? You mention both.
b) Are you doing any delete operations on the target
Target is a file.I mentioned it wrong .
I am not doing any delete operations but only insert or update operation.
And this is working fine most of the times but in between the file becomes empty.
Ae you sure, that everytime you run the map, you are not creating a new file?
Are you using the same source data for each load? Meaning, are you getting different results (empty file, non-empty file) for the same input data?
In the session properties> mapping tab>Targets, what is the value for "Append if exists''?
The logic applied is like this:
When the input file contains a new entry which is not in the lookup file(target file),it is inserted.When the input file contains the same entry as the lookup file,data is updated.
Lookup is done on two fileds in the target file.
So after each run,the data in the target file gets updated or data gets inserted
The way I am looking at it is this -
Your logic seems fine. However, for some reason the target file seems to be overwitten and that is why it is empty(since no deletes are being performed). Try figuring out if some other program is writing out to the file. Or whether your job is over writing it instead of appending to it.As far as lookup is concerned it will cache the data and be done with the file. Hence the questiosn in the previous post-
Anyways, try and figure out why that file is being over written.