Hi,
I have a requirement to read the max month end date from the target and accordingly i need to put the data from source.
For eg: In the target if I have 2011-09-30 date as the max month end date, then I need to pull only the data where the month end date in the source is greater than 2011-09-30. The source data is very huge.
What i did now is read the entire source data, lookup on the target table, pull the max month end data and filter. But this is taking a long time as the soruce data is hude.
Source : Sql Server
Target: Oracle.
Is there a way to pull the data from source by filtering the source sql itself.
what i thought was
Create a after sub routine, and in the subroutine take the max key and write to file. When the job runs for the next time, i want to read the file and use the max date in the file and pass it as a parameter in the source sql. Can some one know how to read a file and pass the value from the file as a parameter.
Thanks in advance
Can we read a file and use
Need to read a column from a file and use as a parameter
Moderators: chulett, rschirm, roy
viewtopic.php?t=141746
Either do the 'max key' work in the current job or a separate followup job, I would consel against the 'after job routine' approach.
Either do the 'max key' work in the current job or a separate followup job, I would consel against the 'after job routine' approach.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers