How to call a value from Text file?
Posted: Wed Dec 06, 2006 12:18 am
Hi all,
I have a requirement for incremental load in such a way that i have to pass the records from the particular timestamp and i am passing that particular timestamp to a sequential file and in the job when i am picking the data from the source table i want the data greater than the time stamp that i have stored in the sequentail file.I am confused with how to call the timestamp in the sequential file when we are using the source stage(i am using user defind sql) .............
Thanks in advance...............
Regards,
Skumar.
I have a requirement for incremental load in such a way that i have to pass the records from the particular timestamp and i am passing that particular timestamp to a sequential file and in the job when i am picking the data from the source table i want the data greater than the time stamp that i have stored in the sequentail file.I am confused with how to call the timestamp in the sequential file when we are using the source stage(i am using user defind sql) .............
Thanks in advance...............
Regards,
Skumar.