rajendar

• Feb 11th, 2006

 

while geeting the data from flat file in informatica ie import data from flat file it will ask for the precision just enter that

madhu sudhan rao

• Feb 13th, 2006

 

while importing the flat file, the flat file wizard helps in configuring the properties of the file so that select the numeric column and just enter the precision value and the scale. precision includes the scale for example if the number is 98888.654, enter precision as 8 and scale as 3 and width as 10 for fixed width flat file

gauravkant

 Profile Answers by gauravkant 

• Feb 13th, 2006

 

you can handle that by simply using the source analyzer window and then go to the ports of that flat file representations and changing the precision and scales.

prasadns26

 Profile Answers by prasadns26 

• Jul 18th, 2006

 

hi,

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.