A Issues

Issues 1) Treat Target Rows as Update:-selected Update as Update in target properties. Then I tried to update some records but in session properties it as Insert…so that I got database error there is no permission to insert.. I made it as Update and reran the session. It was succeeded. 2) One mapping having the Update transformation. In session target properties need to select Insert and Update else Insert property. I.e. if the record is there it will update otherwise it will insert in target table. 3) Records gets fetched in SQ but it wont insert in to target and also those records not rejected. Analyze on it. Finally they are dropped one lookup transformation.

TCS Internal