Refernce lookup

ArndW · Post by **ArndW** » Mon Jan 07, 2008 6:07 am

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?

raji · Post by **raji** » Mon Jan 07, 2008 6:28 am

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.

ArndW · Post by **ArndW** » Mon Jan 07, 2008 7:16 am

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.

raji · Post by **raji** » Mon Jan 07, 2008 7:23 am

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?

chulett · Post by **chulett** » Mon Jan 07, 2008 7:47 am

Replacing it with an ODBC stage would be simpler.

raji · Post by **raji** » Wed Jan 09, 2008 6:42 am

Hi ,

I can able to get the mulitple records using the ODBC stage by check in the option "Reference link with multi row result set".

Thanks for your help.

raji · Post by **raji** » Wed Jan 09, 2008 6:44 am

Hi ,

I can able to get the mulitple records using the ODBC stage by check in the option "Reference link with multi row result set".

Thanks for your help.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 09, 2008 4:09 pm

Only the ODBC and UV stage types have this option.

Time to mark the thread as Resolved?