Informatica Data Warehousing Question:
Download Job Interview Questions and Answers PDF
How to 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.
Import the field as string and then use expression to convert it, so that we can avoid truncation if decimal places inj source itself.
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.
Download Informatica Data Warehousing Interview Questions And Answers
PDF
Previous Question | Next Question |
How to do unit testing in informatica? How to load data in informatica ? | Explain the Differences between Normalizer and Normalizer transformation? |