APT_CombinedOperatorController(3),0: Field 'field' from inpu

deesh · Post by **deesh** » Fri Oct 01, 2010 10:58 pm

Hi,

I am getting below warning , and records are dropping.
Can any one tell me, in which senarios records will drop and what are the solvations for it

Field Decimal(13,3)

APT_CombinedOperatorController(3),0: Field 'field' from input dataset '0' is NULL. Record dropped.

ray.wurlod · Post by **ray.wurlod** » Sat Oct 02, 2010 3:56 pm

Disable operator combination and try again, to determine in which stage this is occurring. At that point we may be able to offer some cogent advice.

nitkuar · Post by **nitkuar** » Mon Oct 04, 2010 5:25 am

not sure, but most probably this is coming due to the use of datastage functions on nullable field in transformer stage derivation. And you are not handling those null values coming from source. Let us know in case you have some other design.