Need to read a column from a file and use as a parameter
Posted: Fri Aug 19, 2011 8:46 am
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
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