How are you running the mapping? is the mapping dynamic? Have you selected the check box to dynamically get the target columns on run time?
In addition to Juan's suggestion above, please do confirm if you're loading this column as well or if it has been kept unmapped from any upstream transformations.
Look into your mapping log and review the INSERT/UPDATE/DELETE sentences.
The 'deleted' column is part of these?
If you can't find that column, then you have the reason why the mapping didn't fail.
May I ask you if any of above answer helped in solving your issue? Otherwise please let us know if you have other queries.
Apologies for replying so late .
The mapping is not dynamic - I run them with no changes in mapping . Only to ensure that due to changes in DB - Does my ETL give me SQL Server error. It is NULL Column it may or may not have value . It has been kept mapped in Upstream Transformation. Source is Hive View and Target is SQL Server - Simple one to one load
I have looked into mapping Log task and did not find any INSERT/UPDATE/DELETE statement as part of Log.
Which means i takes mapping as in-memory and does not seem to map to Actual DB(SQL Server) which confuses me a bit . If we compare the same scenario with Informatica Power Center 10.2.0 HF2 then Power Center Session Log does issue SQL Server error that so and so Column is not found . AsMapping tries to map to actual DB Column.
BTW, As part of my Overall ETL Development - I use two tools , one is Developer (Hive to SQL Server) , other is Power Center (SQL Server to SQL Server source to Target Load)
Informatica Developer Tool 10.2.0
Informatica Power Center 10.2.0
Thank you Lluís for coming back to me . And Thank you everyone for helpful answers.