Friday, May 18, 2007

INFA: Partition problem

I tried to use an aggregator transformation which has two aggregate functions inside. One is MIN and other is SUM of some fields...

When I tried to run it. It throws me an error of Partition License blah blah....

One of our very good folks in our team found a roundabout way for this. Remove the SortedInput option for the aggregator and use a sorter transformation before it. Recreate the session and it should work now.

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