Star Schema Key Definition

[marco_puccetti]

Hello, i need to know how to the following thing:

Table A

  Key A

  Field A

  Field B

Table B

  Key B

  Field C

  Field D

I need to have a Table C Having the Key of both A and B Tables! Is there any simply method to do this?

Table C

  Key A

  Key B

  Field E

  Field F

Thanks

Marco

[marco_puccetti]

Is it correct?

Thanks

Marco

[puttemans]

Hi Marco,

You need to have a link with the key in order for the associative model to work. It would thus rather look like this :

A:

LOAD

     X as Key,

     Y,

     Z

FROM

xx.QVD (qvd);

C:

LOAD

     A as Key, or B-C as Key or B+D as Key

     B,

     C,

     D

FROM

yy.QVD (qvd);

As long as the content of your variable Key in both tables is the same.