Handle decimal places while importing a flatfile
How to handle decimal places while importing a flatfile in informatica?
Expert
While importing flat file definition just identify the scale for a numeric data type. In mapping, the flat file source supports only number data type (no decimal as well as integer). In the SQ associated with which source will have a data type as decimal for which number port of source. Source ->number data type port ->SQ -> decimal datatype. Integers are not supported. Therefore decimal is taken care.
Import field as string and then employ expression to convert it, so which we can avoid truncation if decimal places int source itself.
Explain the Combined Query?
Define the Linked List in data structure?
What is Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
Illustrates all databases should be in third normal form or not?
Write down a brief note on the differentiation between informatics8x and 7x and what is newest version?
Provide a brief introduction of the term slowly changing dimensions (or SCD)?
Illustrates the uses of C++ in Clipper?
Explain the about market structures and price output determination.
Define the explaining plan and how is this used?
What is BCA? Discuss its features?
18,76,764
1934503 Asked
3,689
Active Tutors
1424147
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!