Could anyone please tell me what are the steps required for type2

1. Determine if the incoming row is 1) a new record 2) an updated record or 3) a record that
already exists in the table using two lookup transformations. Split the mapping into 3 seperate
flows using a router transformation.
2. If 1) create a pipe that inserts all the rows into the table.
3. If 2) create two pipes from the same source, one updating the old record, one to insert the new.
Hope this makes sense,