Antwort: Problem with join
Posted: Fri Oct 12, 2001 10:28 am
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
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