Thursday, January 25, 2007

Informatica Learning

I recently learned Informatica(INFA) and started having hands on experiance with it. I wanted to share some of my INFA experiances/issues/solution with all.

RTrim or LTrim takes a parameter which can be a specific string. If the string contains the specified one it trims(deletes) from the actual string given, else leaves it as it is.
For Example: I had a date pattern like '7/8/2006 0:00:00'. I used the RTrim expression as below:
RTRIM(In_str, '0:00:00')
The output of above is '7/8/2006'.

Will publish more as I come across.


Related Posts with Thumbnails