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 |
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
Can any one explain or sujjest some sites for scd mappings.Thank you
Router T/R is active but some people are saying it is also passive which is exactly right?
What is xml source qualifier transformation in informatica?
What is sq transformation?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
What is the advantage of persistent cache? When it should be used.
Separate from a database, an information bazaar, and an information stockroom?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
how to return multiple columes through through un-connect lookup?