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
Hari Babu
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
ReplyDeleteI would be glad If you read and comment. Thanks in advance
Please check Informatica training
Informatica online training
I feel Informatica and other useful aspects actually help people provide more information and useful tools about their many usages.
ReplyDeleteInformatica Read Rest API