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 various types of the designer tools?
Objectives create an external DTD that dictates a relational model-like data structure for XML documents. Assignment 1 Description W
Explain what needs to happen to convert a relation to third normal form?
Specify the data units at the different layers of TCP / IP protocol suite?
What do you understand by the term ACID transaction in DBMS? Describe briefly?
Elucidate briefly power center repository?
Illustrates the term explain and how does this work?
Explain the stage variables?
State some of the sectors where the data warehousing and data mining are utilized.
Explain the difference between expression and aggregator?
18,76,764
1956728 Asked
3,689
Active Tutors
1444420
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!