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 |
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Define mapping and session?
what is session parameters?
How do you create single lookup transformation using multiple tables?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
How the Informatica Server reads perameter file?
How you can differentiate between connected lookup and unconnected lookup?