Rows Getting Rejected in transformer

mac4rfree85 · Post by **mac4rfree85** » 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!!!!!

arvind_ds · Post by **arvind_ds** » Mon Sep 05, 2011 5:26 am

Why are you using IsNull(Col2) in constraints in Transformer stage.? What is your requirement?

udayk_2007 · Post by **udayk_2007** » Mon Sep 05, 2011 5:34 am

IsNull function returns true when a expression evaluates to Null. It may be the case that all the values in col2 are not null which is causing this condition to be false for all the rows.
Did you tried using IsNotNull. Not Sure if that will solve the problem but you can give it a try.

chulett · Post by **chulett** » Mon Sep 05, 2011 7:51 am

Define for us what "rejected" means here. Are they not going down your link because the constraint is false or is Oracle rejecting them?