IICS | Aggregate transformation | #informatica #tamil

Aggregate transformation
1. Aggregate function in general helps to process group of rows specific numeric value and produce single value for our reporting needs.
1. Sales by region, Department wise salaries and so on.
2. This an active transformation the resulted information aggregated results change the output (target) received from input (source).
3. Source - EMP,DEPT
4. Transformation - Joiner (join EMP and dept tables), Aggregate
5. Target - T_EMP_AGG

Scripts used:
row level info:
select
from emp
join dept
aggregate info after grouping:
select
from dept d
join emp e

target table creation:
create table t_emp_agg as
select
from dept d
join emp e
where 1=2