| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: If LKP on target table is taken, can we update the rows without update strategy transformation?
|
| May 05, 2008 10:57:42 |
#2 |
| martin |
Member Since: April 2006 Total Comments: 20 |
RE: If LKP on target table is taken, can we update the rows without update strategy transformation?
|
| Update strategy transformation determines whether to insert, update, delete or reject a record for the target. We can bypass update strategy transformation by creating a router to divide rows based on insert, update, etc and connecting to one of the multiple instances of target. In the session, for that target instance we can check the appropriate box to mark records for insert or update or delete |
| |
Back To Question | |
