Tanubhrt.This.Side

You have to deal with data types all the time in Informatica. There will be lot of conversions and you have to deal with it.

A common error that people do is with ‘Mobile Number’. Now, most often, the mobile number column is given in string and you need to perform some operations on it and then store the number in integer format in the target table.

While doing so, mostly people select the integer data type. But, remember, a mobile number is ten digit and if you try to store it in integer it is bound to get out of range. So, make sure that you store the number in big int.

Now, when I say store it in big int, it does not mean that you need to change the data type of the already given input to you. Even more, you will be surely asked to do some extraction on the phone number. So, may be the number will be given as — (0)94521–45211.

For this make sure your input is still in string otherwise you won’t be able to use SUBSTR. Also, the output variable that you choose must be of the big int format.

Keep this little advice in mind and go get the results.

If you have any queries comment below 🙂

Happy Learning 🙂