Answer / harry

by using Initcap function

Answer / raju

by using initcaps() function in exp tansformation

Answer / giri

By using initcap function

Answer / murugan

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

Answer / ganesh yadav

INITCAP( FIRST_NAME )

FIRST_NAME RETURN VALUE
ramona Ramona
18-albert 18-Albert

Answer / sashanka sekhar panda

select apputil_user.initcap('CORP');

Corp

Answer / tejeya

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

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

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.

3 Answers  

differences between service based and product based?

0 Answers   Satyam,

What aer the out put files that the informatica server creates during the session running?

4 Answers  

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?

3 Answers   Satyam,

Explain what transformation and how many are there in informatica?

0 Answers  

What are the restrictions of union transformation?

0 Answers