Question

11
Views
Arun Kothapalli (Arun.Kothapalli)
CPF Board
Principle Consultant
CPF Board
SG
Arun.Kothapalli Member since 2016 12 posts
CPF Board
Posted: March 10, 2021
Last activity: March 11, 2021
Posted: 10 Mar 2021 20:55 EST
Last activity: 11 Mar 2021 4:18 EST

How to insert default 0 values instead of null using BIX

I have a scenario where I need to insert and default the values to '0' instead of NULL for numeric columns in DB using BIX extraction rule

In DB numeric column is defaulted to  0. But when I run the BIX extract rule, these default column value is replacing 0 and inserting 'NULL'. But requirement is to keep '0' instead of null.

Any suggestions on how to achieve this?

Note: making DB column ad not null is not a feasible option because it fails the insert a record into table.

***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Platform 7.4 Data Integration