Rows Getting Rejected in transformer
Posted: Mon Sep 05, 2011 4:37 am
Hi guys,
My job is a simple job with a Source(Oracle DB) , a transformer and Target(oracle Db).
From source, i am getting 2 columns. In transformer, i will pass only one column(col1) and in constraint i am giving the IsNull(Col2).
The Col1 is Varchar(15) both in source and target. But for some reason, all the rows are gettting rejected.
Can somebody help me to understand as why all the rows are getting rejected. (For debug purpose, i added a seq file as a reject file).
Cheers!!!!!
My job is a simple job with a Source(Oracle DB) , a transformer and Target(oracle Db).
From source, i am getting 2 columns. In transformer, i will pass only one column(col1) and in constraint i am giving the IsNull(Col2).
The Col1 is Varchar(15) both in source and target. But for some reason, all the rows are gettting rejected.
Can somebody help me to understand as why all the rows are getting rejected. (For debug purpose, i added a seq file as a reject file).
Cheers!!!!!