warnings in the Lookup stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Sun Jun 29, 2008 10:19 pm
warnings in the Lookup stage
Hi
I'm getting the wraming as mentioned below
LKP_DenormLICS_ACL,0: Ignoring duplicate entry at table record 9; no further warnings will be issued for this table
How to avoid this warning
I'm getting the wraming as mentioned below
LKP_DenormLICS_ACL,0: Ignoring duplicate entry at table record 9; no further warnings will be issued for this table
How to avoid this warning
Thanks and Regards
Arun
Known is a drop and Unknown is an Ocean
Arun
Known is a drop and Unknown is an Ocean
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
On the Conditions page, where you set the rules for Conditional Lookup and Lookup Failed, there is also a dropdown list of reference input link names. You can choose to allow multiple rows to be returned from one reference input link.
If you want multiple rows to be returned from two reference input links you need two Lookup stages.
If you want multiple rows to be returned from two reference input links you need two Lookup stages.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please purchase premium membership, then my reply will be in "visible format" without me having to do anything at all!
Premium membership is one of the ways that the hosting and bandwidth costs incurred by DSXchange are defrayed. I do not intend to prejudice that funding by establishing a precedent of bypassing it.
Premium membership is one of the ways that the hosting and bandwidth costs incurred by DSXchange are defrayed. I do not intend to prejudice that funding by establishing a precedent of bypassing it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 71
- Joined: Mon Jul 09, 2007 1:12 pm
Lookup Source should only have 1 record per lookup key from the transformer. Ideally lookup should only match on 1 row in the lookup source and return that row only.
Fix your source and see there is only 1 row per primary key.
Note: Please get premium membership. I have been a premium member
and tell you what? You won't regret it.
Fix your source and see there is only 1 row per primary key.
Note: Please get premium membership. I have been a premium member
and tell you what? You won't regret it.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No.
That would getting into Cartesian product territory. "They" thought that that would be a Bad Thing.
You can use more than one Lookup stage. But you still risk generating a Cartesian product.
That would getting into Cartesian product territory. "They" thought that that would be a Bad Thing.
You can use more than one Lookup stage. But you still risk generating a Cartesian product.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.