Re: lookups stuff
2 views
Skip to first unread message
Sats
Jun 28, 2010, 3:57:30 PM6/28/10
to Tom Nats, Jimmy Fierro, Bill Stalnaker, Nirmal Ramalingam, denver-infor...@googlegroups.com
Yeah.. thats a dynamic lookup.
On Mon, Jun 28, 2010 at 1:55 PM, Tom Nats <t...@t10.net> wrote:
Dynamic lookup?On Mon, Jun 28, 2010 at 1:51 PM, Jimmy Fierro <jfi...@healthgrades.com> wrote:
Hey what are the lookup settings again for lookups if you want to re-cache the table after every insert per session run?
Example for a empty target table:
Row 1 insert with value ‘A’
Row 2 update value ‘A’ due to existing from Row 1
Jimmy Fierro
Data Infrastructure Team
HealthGrades: Guiding America to Better Healthcare™
NASDAQ: HGRD
Tom Nats
Jun 28, 2010, 4:07:34 PM6/28/10
to Sats, Jimmy Fierro, Bill Stalnaker, Nirmal Ramalingam, denver-infor...@googlegroups.com
Go to help, search, dynamic lookup.
Satish is the expert, I'm sure for $65 an hour he'll show you how to use them. haha
Satish is the expert, I'm sure for $65 an hour he'll show you how to use them. haha
Sats
Jun 28, 2010, 4:19:09 PM6/28/10
to Tom Nats, Jimmy Fierro, Bill Stalnaker, Nirmal Ramalingam, denver-infor...@googlegroups.com
haha ... Let me know if you want help with the dynamic lookup. I can tell you how it works. I realised a lot had changed from the last time I used it.
The bigger problem we faced was that the multiple updates were not being applied on the target table.
We used that transaction control transformation to solve that issue. I can tell you how we implemented that if you have the same issue.
Sats
The bigger problem we faced was that the multiple updates were not being applied on the target table.
We used that transaction control transformation to solve that issue. I can tell you how we implemented that if you have the same issue.
Sats
Reply all
Reply to author
Forward
0 new messages