1.

How Do You Handle Decimal Places While Importing A Flatfile Into Informatica?

Answer»

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.

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.


Discussion

No Comment Found

Related InterviewSolutions