Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Stragedy for a lookup not cached

Status
Not open for further replies.

gwright2005

Programmer
Feb 28, 2005
1
US
I am using Informatica 7.1, I have disabled the lookup cache (cannot use dynamic cache all conditions are not equal). Example the condition is looking for a update flag from the target table as a 'N'. My update stragedy is changing this flag to 'Y'. I have multiple input records and should update the target only once, but when I am in debug, it updates multiple times. I changed the workflow to not cache the lookup and the commit type is target and 1 row.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top