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
Is there any way to read the ms excel datas directly into informatica?
Write the program through which the records can be updated?
Implementation methodology
How do you set a varible in incremental aggregation
4 yrs etl devloper roles and responsibilities?any body give solutions
what are the deliverables?in your project?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How union transformation is used?
What is aggregate cache in aggregator transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to do unit testing in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is a shortcut and copy in Informatica and how two are different with each other?
Is it possible to revert a global repository to local one and why?