Hi @jayakrishnaaparthasarathy ,Firstly, Identity fields are only
required if you building real-time customer profiles. They are not
required if you are only ingesting data into the data lake. Second, if
you get into a situation where you can't afford values to be null you
can make use of "coalesce" function which returns first non-null object.
IN your case if you want to replace empty email with some default
email/string you can try "coalesce(EMAIL,"defaultEmail@example.com")