How to display First letter of Names in Caps?
Answers were Sorted based on User's Feedback
Answer / raju
by using initcaps() function in exp tansformation
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / murugan
by using expression transformation ...we can use this function
init caps...
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ganesh yadav
INITCAP( FIRST_NAME )
FIRST_NAME RETURN VALUE
ramona Ramona
18-albert 18-Albert
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sashanka sekhar panda
select apputil_user.initcap('CORP');
Corp
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / tejeya
We can get this one by using upper(substr(name,1,1))
| Is This Answer Correct ? | 7 Yes | 11 No |
How to load query faster,so that It will take less time to load?
What is the surrogate key?
Where is the cache stored in informatica?
why do we go for update strategy tr in SCD rather using the session properties?
What are active and passive transformations?
what is the difference between copy object import objects using repositery manager which one is best
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
how do u use sequence created in oracle in informatica? Explain with an simple example
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
what is dynamic cashe
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
how can one eliminate dupliacte data with out using distinct option?