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.
Name the areas where data structures are applied broadly?
Briefly describe snow flake system design in database?
What is meant by the data modelling?
Write down the purpose of Fact-less Fact Table?
Illustrates the term tkprof and how is this used?
Explain the term power center repository?
Why do not you utilize GNU SCONS or autoconf for building?
How to produce an Auto Incremental Number within a SSIS Package?
Specify the types of the tracing level?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
18,76,764
1928945 Asked
3,689
Active Tutors
1441470
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!