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 |
What are the data movement modes in informatica?
Make a note of the quantity vaults made in informatica?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
In development project what is the process to follow for an etl developer from day1
can we override a native sql query within informatica? How do we do it?
How can we use batches?
what is the use of Java Transformation in Informatica 8.x?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
how can one come to know wether the records loak into the target if we use update strategy
What are the types of maping in Getting Started Wizard?
Enlist the differences between database and data warehouse.
how to sort date field in infomatica?