1.SOURCE

Source is imported from thedatabase.Here EMP table takesn as source.

2.SOURCE QUALIFIER

The data from sourse is passed to Source Qualifier. Here source datatypes are converted into Informatice data types.It has got outp[ut ports to pass data to the respective tranformation.Here , the values are passed into the lookup tranformation.

3.LOOKUP TRANFORMATION(LKP_Getdata)

Analyse the rows that dont update in any case(preferably the primary or composite keys) . These values are to be defined again in new ports with new names. Here in the above example, empno,ename and hiredate are defined as IN_EMPNO,IN_ENAME and IN_HIREDATE.Map the EMPNO,ENAME,HIREDATE from source qualifier to IN_EMPNO,IN_EMPNAME,IN_HIREDATE in lookup(These the only input ports). A unique key is created in adition to the lookup values.Here PM_Primary key is created.

a)In the properties tab, define the condition . Here we need to define ,
EMPNO=IN_EMPNO, ENAME=IN_ENAME,HIREDATE=IN_HIREDATE

b) Check the other required properties and also check for the connectivity if its a relational data source.

4.EXPRESSION TRANFORMATION (EXP_DetectChanges)

 a) Pass values(except the input values defined in lookup) from Source Qualifier into Expression tranformation(exp_detectchanges). Create two output ports CHANGEDFLAG(integer) and NEWFLAG(integer).Pass the unique key (PM_PrimaryKey) into the exp tranformation and map it . Create the comparison column for all the values (comm,deptno,sal,mgr). Map the lookup values to these comparision keys.

b) pass the lookup PM_primarykey to exp PM_primarykey.

c) Make sure only changed flag and new flag are the only output ports here .