Replace Synthetic Key with LinkTable

[#1]

Dear QVExperts,

How to replace the Synthetic Table with LinkTable.

Can you please suggest me on this.

Thanks

Sasi

[#2]

Thanks Everyone for the valued Suggestions.

Resolved the issue.

[#3]

Hey Sasi,

I work for Pernambuco (State of Brazil) Government, and here we deal with LAAAARGE DATAS. So, we have to use LinkTable like I demonstrate in this attachment.

Your data structure should look like this:

The linktable is constructed like follows:

//HERE THESE LINK TABLES SHOULD NATURALLY BE CONCATENATED

LINKTABLE:

LOAD

    YEAR&'-'&MONTH as %YEAR_MONTH_INCENTIVE_KEY,

      null() as %YEAR_MONTH_SALES_KEY,

      null() as %YEAR_MONTH_RETURN_KEY,

      YEAR,

      MONTH

FROM

[LINTABLE.xlsx]

(ooxml, embedded labels, table is INCENTIVE);

LINKTABLE:

LOAD

      null() as %YEAR_MONTH_INCENTIVE_KEY,

      YEAR&'-'&MONTH as %YEAR_MONTH_SALES_KEY,

      null() as %YEAR_MONTH_RETURN_KEY,

      YEAR,

      MONTH

FROM

[LINTABLE.xlsx]

(ooxml, embedded labels, table is SALES);

LINKTABLE:

LOAD

      null() as %YEAR_MONTH_INCENTIVE_KEY,

      null() as %YEAR_MONTH_SALES_KEY,

      YEAR&'-'&MONTH as %YEAR_MONTH_RETURN_KEY,

      YEAR,

      MONTH

FROM

[LINTABLE.xlsx]

(ooxml, embedded labels, table is RETURN);

The null() statements are for standardize the LinkTable for a natural concatenation.

[marcus_sommer]

It's a possible way but I doubted it that it's best way by LAAAARGE DATAS by which is mostly better to have a single fact-table.

- Marcus

[#5]

But when you have single fact table the data structure doesn't show as much as we need.

I agree that have a single fact is the easiest way, simply concatenate everything... but sometimes we need to "see" what's going wrong, and link table helps a lot.

One fact table for 30 facts from diferent databases will not help.

Giba