how to access 5 days worth of data

ravikiran2712 · Post by **ravikiran2712** » Mon Dec 06, 2004 7:35 pm

hi ,
i am developing a parallel job in which the design is as follows,

transformer-------> lookup<------- oracle.
the transformer outputs records in which i have a date field. i will have to look up into the oracle stage for the past 5 days worth of records depending on the date field output by the transformer.
please reply fast.
rk

kcbland · Post by **kcbland** » Mon Dec 06, 2004 9:46 pm

Your description of the job design is incomprehensible. Could you please restate the design and your requirements?

ravikiran2712 · Post by **ravikiran2712** » Tue Dec 07, 2004 6:55 am

hi,
i will have to access previous 5 days(depending on the date field output by the transformer) from the oracle database stage.i mean i want the design which can be used to do this involving an oracle database stage a transformer and any processing stage.
thankyou
rk

ray.wurlod · Post by **ray.wurlod** » Tue Dec 07, 2004 2:59 pm

Is there a mechanism in the database table that allows you to answer the question "5 days worth"?
Then surely the simplest mechanism is to use an appropriate date difference function in the extraction SQL. For example

Code: Select all

SELECT columns FROM table WHERE datefield >= (sysdate - 5);

T42 · Post by **T42** » Mon Dec 13, 2004 4:47 pm

You can also pass the date field from Oracle, and match it with the valid date fields from the Transformer. Yes, a lot of duplications. Range matching is not available just yet (coming soon...)