I am performing checks to see if data in DB and in file are same.
DB_input -> This is the hash containing data from DB
ebal_nl -> File containing data to compare with
Both are connected via a tmap.
I am running inner join with unique match and file is main in tmap and db is the lookup in tmap. There are 4 rows in file which are not there in DB. When the comparison occurs, I see instead of nulls for records not present in DB but present in file, the values gets default to '0'. Please let me know if anyone has faced this issue ?
I am always getting the expected value as NULL for the sales column. Could you please remove the length, precision and default values for the sales column and try to retest it?
But like I said earlier, you would not have to worry about the value in lookup tables for reject as they will be always null (du to no match). So you should always pass the values of main flow so that source team can verify the results of rejected records.
If the answer has helped to resolve your query, could you please mark the topic as resolved? Kudos are also welcome 🙂
