How to display First letter of Names in Caps?

Answers were Sorted based on User's Feedback



How to display First letter of Names in Caps?..

Answer / harry

by using Initcap function

Is This Answer Correct ?    26 Yes 2 No

How to display First letter of Names in Caps?..

Answer / raju

by using initcaps() function in exp tansformation

Is This Answer Correct ?    18 Yes 0 No

How to display First letter of Names in Caps?..

Answer / giri

By using initcap function

Is This Answer Correct ?    11 Yes 0 No

How to display First letter of Names in Caps?..

Answer / murugan

by using expression transformation ...we can use this function
init caps...

Is This Answer Correct ?    7 Yes 0 No

How to display First letter of Names in Caps?..

Answer / ganesh yadav

INITCAP( FIRST_NAME )

FIRST_NAME RETURN VALUE
ramona Ramona
18-albert 18-Albert

Is This Answer Correct ?    6 Yes 0 No

How to display First letter of Names in Caps?..

Answer / sashanka sekhar panda

select apputil_user.initcap('CORP');

Corp

Is This Answer Correct ?    1 Yes 0 No

How to display First letter of Names in Caps?..

Answer / tejeya

We can get this one by using upper(substr(name,1,1))

Is This Answer Correct ?    7 Yes 11 No

Post New Answer

More Informatica Interview Questions

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,


What differs when we choose the sorted input for aggregator transformation?

0 Answers  


What is a data modeling?

2 Answers  


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?

4 Answers   Mind Tree, Polaris,


What is a joiner transformation and why it is an active one?

0 Answers  






I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,


Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,


what are the deliverables?in your project?

0 Answers   DELL,


What are differences between Informatica 7.1 and 6.1

3 Answers  


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?

2 Answers  


What is a snowflake schema?

0 Answers  


Categories