Size limit on sequential file stage
Posted: Wed Apr 04, 2012 3:16 pm
Hi,
I have the following requirement.
I have a lookup stage and in stage properties I put if look up fails then go to reject link. In the reject link I put sequential file.
The data is huge and I have to set size limit on sequentail file in reject link
as 2MB and once it reaches the 2MB limit it has to go to the new file.
So, I need to set up the size limit on sequential file and at the same time once the size limit reached it has to go automatically to another file.
My source and target both are oracle.
Could someone help me to find solution for this.
I need to put a timestamp in rejected records in sequential file.
I can create timestamp in transformer, but do not know how to pass it to sequential reject file through lookup failure link.
Thanks,
Sridhar
I have the following requirement.
I have a lookup stage and in stage properties I put if look up fails then go to reject link. In the reject link I put sequential file.
The data is huge and I have to set size limit on sequentail file in reject link
as 2MB and once it reaches the 2MB limit it has to go to the new file.
So, I need to set up the size limit on sequential file and at the same time once the size limit reached it has to go automatically to another file.
My source and target both are oracle.
Could someone help me to find solution for this.
I need to put a timestamp in rejected records in sequential file.
I can create timestamp in transformer, but do not know how to pass it to sequential reject file through lookup failure link.
Thanks,
Sridhar