| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: Update Strategy
Answer: In which situation do we use update strategy? |
| July 07, 2009 02:22:22 |
#6 |
| chiranjoydas |
Member Since: July 2009 Total Comments: 1 |
RE: Update Strategy
|
| Update Strategy is used in case fo Updating a record if the same exists in the table. For that we need to have a primary key in the Informatica level even if the same is not present in database level. If no key is defined we need to use 'update override' in the target. Also when using this transformation click the 'Data Driven' property in the Session. |
| |
Back To Question | |
