We have a job which we just realized isn’t working properly. Its data flow is quite simple:
0HR_PT_1 -> QUERY -> MAP_CDC -> Destination table.
The query doesn’t really do anything.
We wound there were about a dozen records for one day for a person (all but one had negative hours). When we cleared out the table and did an initial load, there is now 1 record for the same. Is that normal behaviour ? Should we we doing something different with this extractor ?
I know it isn’t on the supported list, but if anyone could enlighten me i’d appreciate it.
Thanks.
Leigh Kennedy (BOB member since 2012-01-17)