Tuesday, 10 May 2016

How to calculate count of duplicate records in Informatica?

Source 
Name, no, salary
Hari, 10, 10K
Babu, 20, 30K
Hari, 10, 10k
Naidu, 10, 40k

Target 

Name,No,Salary, count
hari ,10,10k,          2
Babu, 20 ,30K      1
naidu,10 ,40k       1




  • Create an expression transformation, connect all ports from source qualifier to expression.
  • Add other output port to expression with O_ENAME
  • O_ENAME=ENAME
  • Create aggregator transformation, connect all ports from expression to aggregator.
  • In the aggregator, groupby on all columns
  • Write a expression on O_ENAME
  • O_ENAME=count(ENAME)
  • Connect all ports from aggregator target
  • connect O_ENAME to COUNT in target  

output will be 

hari,  10,    10k,     2
Babu, 20 ,30K      1
naidu,10 ,40k       1

Regards,
Hari Babu

2 comments:

  1. Very useful post. This is my first time I visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up. I also wrote an article about Informatica online training
    I would be glad If you read and comment. Thanks in advance
    Please check Informatica training
    Informatica online training

    ReplyDelete
  2. I feel Informatica and other useful aspects actually help people provide more information and useful tools about their many usages.

    Informatica Read Rest API

    ReplyDelete