1)how to implement the logic in procedures if the source side data deleted that will reflect the target side table ANS)User this query on Command on target Delete from Target_table where not exists (Select 'X' From Source_table Where Source_table.ID=Target_table.ID). 2)if the src hav total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records ANS) Use IKM Incremental Update Knowledge Module for Both Insert n Update operations. 3)can we implement package in package? ANS:) Yes we can call one package into other package. 4)how to load the data with one flat file and one rdbms table using joins? ANS:) Drog n drop both File and table into source area and join as in Staging area. 5)in the package one interface got failed how to know which interface got failed if we no access to operator? ANS:)Make it mail alert or check into SNP_SESS_LOg tables for session log details. 6)...