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 is operational data source (ODS)?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
what is bridge tables in informatica
What is an aggregator transformation? it is active why cant it be passive explain?
why sequence generator should not directly connected to joiner transformation ?
Why we need XMLs?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.