Informatica Data Warehousing Interview Question:

How to handle decimal places while importing a flatfile into informatica?

Submitted by: Administrator

while importing flat file definetion just specify the scale for a neumaric data type. in the mapping, the flat file source supports only number datatype(no decimal and integer). In the SQ associated with that source will have a data type as decimal for that number port of the source.

source ->number datatype port ->SQ -> decimal datatype.Integer is not supported. hence decimal is taken care.

Import the field as string and then use expression to convert it, so that we can avoid truncation if decimal places inj source itself.
Submitted by: Administrator