top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

replace null with 0 for the returned from count(*) function of aggregator in informatica

0 votes
415 views

I am using aggregator transformation in my Informatica mapping where I am counting number of records coming from sql override.I need to pass zero value to target table as counts in case if I get 0 number of return counts from count(*) function of Aggregator Transformation.

posted Dec 15, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Yo can do someting like this:

count(IIF(isnull(AGG_PORT),0,AGG_PORT))

That should do it.

answer Dec 18, 2014 by Shweta Singh
Similar Questions
+1 vote
What can we do to improve the performance of Informatica Aggregator Transformation?

What can we do to improve the performance of Informatica Aggregator Transformation?

+1 vote
How to extract the number(0-9) from the string in informatica?

I want to extract the number(0-9) from the string. e.g.
1.if src is *J$456*&56 then tgt should be 45656
2.if src is &*(>123>>789&^ then tgt should be 123789

This is just an example, special characters or alphabets are random in string, so how to extract only numbers?

...