Hi Dhiraj ,
I am getting ERROR CODE - 2794 while loading data from source to target using informatica.
And there is no duplicates in source system.
Can you please help me why i am getting error code - 2794 eventhough there are no duplicates at source end.
Thanks in advance !
For example, if the data types change then perhaps the data becomes duplicate, e.g. '00', '0','' all could map to an integer value of 0.
Or perhaps the source system is case-specific for string comparisons and your target is defined / defaulted to NOT CASESPECIFIC.
Or you may have VARCHAR data that differs only in trailing spaces (which are not significant in standard / Teradata SQL; but Oracle, in particular, considers different numbers of trailing spaces to be different values).