Antwort: Problem with join

[admin]

Hi Nuno

use for the Table B an ODBC-Stage and set in the Transformer for the Lookup the Link Property "Refernce link with mult row result set"

regards

Udo





Nuno Pimenta on 12.10.2001 10:17:39

Bitte antworten an datastage-users@oliver.com

An: "LIST-DataStage (E-mail)"
Kopie:
Thema: Problem with join



Hi all,

I have the following problem that i dont know how i can resolve.

I have a file (A) that contains numbers,

A ( may be 1000 records)
Key
----
1
2
4
...

and i have to join with a table (B) that have 5 millions of records.

B (5 millions of records)
Key Desc
-------------------
1 A
1 B
1 C
2 A
3 A
4 A

...

But that join may be return more that one record by Key and i want the all the records, but only one is returned.

So, i want to use A as source and B as reference for questions of performance, but, how can i obtain all the records in this scenario?

Result
Key Desc
--------------------
1 A
1 B
1 C
2 A
4 A

How can i achieve this result?


Thanks in advance,


Nuno Pimenta