Need a help on multiple Synthetic Key

[#1]

i m Creating a Practice Demo on Inventory Management.. in  this  i have a 3 Table.. Consumption , Order and Physical Stock..

But the Problem is that if i m Loading table Multiple Synthetic Key get generated..

Consumtion Table Column are,

[FA Type],

  [Part Number],

  [Part Description],

     [Serial Number],

     [Mat. Class],

     [Mat. Type],

[ATA Chapter],

Tool,

    [Cost Center],

     Receiver,

[Booking Date],

[Consumed Qty],

Amount

and Order Table Column are,

[FA Type],

  [Order No.] as [Order Number],

     [Order State],

Date as [Order Date],

[Part No.] as [Part Number],

     [Serial No. / Batch No.] as [Serial Number],

     [Label No.] as [Label Number],

     Description as [Part Description],

     Qty. as OrderQty,

Rate,

[Invoice No.],

     [Invoice Amt.],

[Material Type],

     [Default Supplier],

so how to link this .. can we Join both the table in one and Classify and the data with Flag of Consumption and order.. Either any Better Way

[tyagishaila]

Hi Brijesh,

You can make Composite Key to associate both tables and rename same name fields to avoid synthetic key.

e.g.

TAB1:

Load

A,

B,

C,

D,

A+B+C as key                                      //Composite Key

From....

TAB2:

Load

A as Anew,                                         // Rename Field

B as Bnew,

C as Cnew,

F,

A+B+C as key

From.....

Now tables/charts will associate on the basis of A,B and C.

hope it will help you.

[#3]

so u have multiple synkeys in data model means u have more common fields between the tables.....then if u want avoid... u can use Qualify statement....