BIGINT issue in Informatica:-
Last few days ago i found some discrepancy with using BIGINT in Informatica.
When i am going to convert any decimal value to bigint its working fine ...
but issue is occurred to convert when having 0 is starting of any character.
Suppose 01234.0000 is source column and we need to convert it into bigint
Lets suppose wht do u think ....wht will be value...looks it .
01234
Firstly i thought it was 01234....but i got surprise when i debug the ETL for perticular column.
it was 1234. (Means 0 is removed)
so becareful before use of BIGINT in informaTica
Last few days ago i found some discrepancy with using BIGINT in Informatica.
When i am going to convert any decimal value to bigint its working fine ...
but issue is occurred to convert when having 0 is starting of any character.
Suppose 01234.0000 is source column and we need to convert it into bigint
Lets suppose wht do u think ....wht will be value...looks it .
01234
Firstly i thought it was 01234....but i got surprise when i debug the ETL for perticular column.
it was 1234. (Means 0 is removed)
so becareful before use of BIGINT in informaTica
No comments:
Post a Comment