Refernce lookup
Moderators: chulett, rschirm, roy
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
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: