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 |
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
What differs when we choose the sorted input for aggregator transformation?
What is a data modeling?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
What is a joiner transformation and why it is an active one?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
what are the deliverables?in your project?
What are differences between Informatica 7.1 and 6.1
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
What is a snowflake schema?