How Do You Handle Decimal Places While Importing A Flat file Into Informatica?
Ch KashifEnlightened
Power BI
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
How Do You Handle Decimal Places While Importing A Flat file Into Informatica?
Ch Kashif
while importing flat file definition just specify the scale for a numeric 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.