CREATE TABLE #UICasePDSHistory(SourcePDSHistoryId INT, TargetPDSHistoryId INT)
MERGE Migration_UI_501_Murali.dbo.UICasePDSHistory AS TGT
USING
(
SELECT A.PDSHistoryID, B.TargetLocalId, C.TargetPDS_Id, A.LastAccess
FROM 
Migration_ACTUS_462.dbo.UICasePDSHistory A
JOIN MigrationConfig.dbo.NLPCaseMasterMapping B on A.LocalID = B.SourceLocalId
JOIN MigrationConfig.dbo.UIPluggableDataSourceMapping C on A.PDS_Id = C.SourcePDS_Id
) AS SRC
ON 1 = 0
WHEN NOT MATCHED THEN
INSERT(Pds_ID, LocalID, LastAccess)
VALUES(SRC.TargetPDS_Id, SRC.TargetLocalId, SRC.LastAccess)
OUTPUT SRC.PDSHistoryID, INSERTED.PDSHistoryID INTO #UICasePDSHistory;