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 many repositories can we create in Informatica??
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
HOW TO DELETE A RECORD FROM FLAT FILE
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
differences between service based and product based?
What aer the out put files that the informatica server creates during the session running?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
Explain what transformation and how many are there in informatica?
What are the restrictions of union transformation?