how can you load data into target table without leading zeor's
Answer Posted / srini
By using the Trim function we can able to Remove the
leading Zero's in a value and we can load it in to target.
Function : trim(Col_Nm,'0',L)
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Explain the different dimensions.
Explain sessions?
Explain what are the different types of transformation available in informatica.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Why union transformation is an active transformation?
Which version configuration tool used in ur project?
What is olap (on-line analytical processing?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How do we call shell scripts from informatica?
What is the need for an etl tool?
how many types of dimensions are available in informatica?
Why is sorter an active transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what is size of u r database?
What is a standalone command task?