Writing records into outout stage, even if no records comes
Posted: Tue Dec 16, 2003 9:31 am
Hi Everyone,
I have a small issue. There is one simple job, which
takes data from an oracle
table and writes the data into a sequential file.
There is one transformer stage
between this 2 stage.
The problem is that we are selecting records from
oracle table based on some
condition. And it's quite possible that because of
that condition the OCI stage
might not return any row, in that case nothing gets
written on the output sequential
file. My requirement is that even if no records is
coming from the OCI stage,
I have to write a dummy records in the sequential
file.
Please let me know how I can achieve this.
Thanks & Regards,
Bipul
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
I have a small issue. There is one simple job, which
takes data from an oracle
table and writes the data into a sequential file.
There is one transformer stage
between this 2 stage.
The problem is that we are selecting records from
oracle table based on some
condition. And it's quite possible that because of
that condition the OCI stage
might not return any row, in that case nothing gets
written on the output sequential
file. My requirement is that even if no records is
coming from the OCI stage,
I have to write a dummy records in the sequential
file.
Please let me know how I can achieve this.
Thanks & Regards,
Bipul
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/