January 18, 2012 at 5:29 pm
select * from customers where load_tmstp between (select max(end_tmstp) from log) and sysdate.
Customer table do have some records where load_tmstp is between max(end_tmstp) and sysdate but i am not getting any records in destination( though the package runs successfully). Database is oracle.
max(end_tmstp) LOOKS LIKE THIS : 18-JAN-12 07.18.59.000000000 PM
and load_tmstp has value that lies between the above value and the sysdate(current timestamp when i run the job)
Any idea why i am getting zero records.
Thanks
January 20, 2012 at 9:17 am
Are you getting records in the *source*?
Try running your query directly in an Oracle DBMS and see what it returns. If you are not getting rows from the source, your query has problems. If you are, but there are no records in your destination, then one of your transformations is causing them to be lost - most likely either a conditional split, a lookup transform with a redirect on error that goes nowhere, or a merge join that does a join operation and doesn't find any matching records.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply