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
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is meant by lookup transformation?
What are the guidelines to be followed while using union transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Describe an informatica powercenter?
Explain lookup transformation source types in informatica
What is informatica?
What are the different types of repositories created using informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Please let me know how to make encryption and decryption with example?
Is it possible to revert a global repository to local one and why?
What do think which one is the better joiner or look up?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the reusable transformations?
What is informatica etl tool?