I am trying to read data from ldap and load it into sql server table. While loading IAM checking the phone(us format) and email format using code routines in tMap. In source, phone and email columns may having null or empty values. Code routines return null if the format doesn't match. In database, these two columns are nullable. Whenever null or empty comes from source, job is throwing null pointer exception in tMap
Any field that you use code to manipulate needs to do null checks before the manipulation if null values are being passed. Try: !Relational.ISNULL(fieldName) && fieldName.length() > 0 ? codeToDo :null
The NULL check and empty value verification can be done by above post. There are two specialized components in Talend which can perform Data Quality checks for email and Telephone numbers.
Please utilize them for data quality checks before inserting data to target table. The links for both components are as below.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
