ETL job filter data base on date supply by database

h4rd1 · Post by **h4rd1** » Fri Nov 13, 2009 6:59 pm

Dear all

i'm new in using datastage, do any one know how to filter a data from source base on the date supply by database ?

Thanks

Hardi

kduke · Post by **kduke** » Sat Nov 14, 2009 12:20 am

You have to either join to get the date or write a job just to extract the date and write it to a sequential file. Have another job or routine read this date a feed it as a parameter to the main job.

h4rd1 · Post by **h4rd1** » Sat Nov 14, 2009 10:55 am

Thanks for the Reply

Can i directly do that in the job ?

Thanks

Hardi

ray.wurlod · Post by **ray.wurlod** » Sat Nov 14, 2009 12:58 pm

chulett · Post by **chulett** » Sat Nov 14, 2009 3:10 pm

I don't see why not - providing this "filtering" can be done in the source query. To be honest, though, I didn't really grok the original question.

vjonnala1516 · Post by **vjonnala1516** » Sat Nov 14, 2009 7:50 pm

just keep the filter/constraint in the base query itself.

h4rd1 · Post by **h4rd1** » Sun Nov 15, 2009 7:12 pm

Thanks for the Help

i use parameter set and i add a job that supply the value into the parameter job file.

Thanks