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 do you understand by a term domain?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
My source table having some records ,i want load 1st record and last record into one target?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
what is the difference between lookupoveride and joiner?
In target table how to display the system time
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What are pre and post-session shell commands?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,