How to display First letter of Names in Caps?

Answer Posted / ganesh yadav

INITCAP( FIRST_NAME )

FIRST_NAME RETURN VALUE
ramona Ramona
18-albert 18-Albert

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1733


Explain sessions. Explain how batches are used to combine executions?

595


How to call shell scripts from informatica?

577


Which are the different editions of informatica powercenter that are available?

557


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1079






Target increases every day even though no new record was inserted

1107


Sequence generator, when you move from develoment to production how will you reset

1406


How to load last n records of file into target table - informatica

598


tell me the rules and responsblites in our project(my project is development)

1497


How to generate sequence numbers using expression transformation?

640


Name at least 5 different types of transformations used in mapping design and state the use of each.?

670


What are ETL Tools?

666


What is a surrogate key?

561


What is rank transformation?

579


How do you convert single row from source into three rows into target?

605