Refernce lookup
Moderators: chulett, rschirm, roy
The first thing you need to do is figure out what you want to do. Which of the 10 returned records do you wish to use? Will any of the rows suffice? Do you wish to work on all 10 records?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Thanks for your reply.
Yes, we want all those 10 records in the target which are all unique by another two keys.
For example, the data looks as below:
key1 key2 key3 key4(absent in lookup) key5(absent in lookup)
100 xxxx yyy 1 a
100 xxxx yyy 2 b
100 xxxx yyy 3 c
100 xxxx yyy 4 d
100 xxxx yyy 5 e
100 xxxx yyy 6 f
.
..
..
..
so we are in need of those 10 rows.
Yes, we want all those 10 records in the target which are all unique by another two keys.
For example, the data looks as below:
key1 key2 key3 key4(absent in lookup) key5(absent in lookup)
100 xxxx yyy 1 a
100 xxxx yyy 2 b
100 xxxx yyy 3 c
100 xxxx yyy 4 d
100 xxxx yyy 5 e
100 xxxx yyy 6 f
.
..
..
..
so we are in need of those 10 rows.
Raji
Nothing is impossible because impossible itself
says I'm Possible
Nothing is impossible because impossible itself
says I'm Possible
If you want to get the duplicates, I think you will need to use a UV stage (or ODBC) to return all those duplicates instead of using a hashed file type stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Thanks.
I am using the Dynamic RDBMS stage for lookup table.
So, Shall i replace it with the UV stage?
Is it any work that i have to do with the uvodbc.config file?
In the uvodbc.config file, already the following entry for the UNIVERSE is present.
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
Is anything else i need to add in the uvodbc.config file?
I am using the Dynamic RDBMS stage for lookup table.
So, Shall i replace it with the UV stage?
Is it any work that i have to do with the uvodbc.config file?
In the uvodbc.config file, already the following entry for the UNIVERSE is present.
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
Is anything else i need to add in the uvodbc.config file?
Raji
Nothing is impossible because impossible itself
says I'm Possible
Nothing is impossible because impossible itself
says I'm Possible
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: