How do you handle decimal places while importing a flatfile into informatica?




while importing flat file definetion just specify the scale for a neumaric data type. in the mapping, the flat file sourcesuppor ts 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.

No comments:

Post a Comment