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.
Specify the types of dimensions which are available in the Informatica?
Illustrates the applications of ASA?
What is meant by the Surrogate key?
When must you seem de-normalization?
How can we remove duplicate rows from the flat file?
Illustrates the license for Clipper?
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
In JDBC driver which coding pattern is use? Describe briefly?
Give a brief introduction of the term active data warehousing?
Explain the Aggregate Awareness?
18,76,764
1940659 Asked
3,689
Active Tutors
1415441
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!