on 06-16-2008 9:38 AM
Hi all,
I have a DSO which is loaded by 2 flatfiles. The DSO is loaded with the first flatfile and activated. The second flatfile is loaded and active records are updated with additional information.
The data is loaded into the next DSO with the delta. The problem is that changed records from the first DSO have 3 records in the change log. These records are not loaded correctly in the second DSO.
As an example: In the first flatfile I load employee number with the costcenter and the FTE number. In the second file, I update the employee nr with the contract type. When loading to the second DSO, some records are correct with all 3 fields filled, but some only have employee number with the costcenter.
The change log is correct, but it looks like the delta load from the change log is not in the correct sequence. I need a delta load, because I am loading every month.
Does anybody has any idea how to solve this.
Thanks in advance
Regards,
Paul
Hi,
do you have different transformations for those loads? If not, the error might be that you are normally updating all the fields of your dso from both sources but the delivered fields will then overwrite each other depending on the key.
Let us know.
regards
Siggi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.