Passing a value where NULL in the QUary Transform

dataservices job design
1

Hi,

I am getting NULL values in to my table but I would like to insert 00 when the NULL comes in my query transform mapping.

I am trying to do the below

ISNULL(NULL,‘00’) as Query.“CompanyFilter Revenue_Band”;

Can you please correct?.

Thanks

rmuvva (BOB member since 2010-03-30)

2

DS is Oracle-centric. IsNull is t-sql. Use nvl(). The manual would have been a good place to look.

eganjp :us: (BOB member since 2007-09-12)

3

Thanks…its woring

rmuvva (BOB member since 2010-03-30)