modelling

[surajap123]

Hi All,

For a booking there are many invoice line items.

The booking details are in table1 and invoice details are in Table2.

Both the tables can be linked with keyfield bookingID.

-Since there are many common fields between both tables, i see lot of synthetic keys created.

-I wanted to put both TableA and TableB in one table.

What is the best i can do to achieve this?

Should i go with concatenate, left join or anything else?

I have one more query, Is booking table and invoice table both are fact tables. I think no. because both tables have same transaction details.

Regards,

Suraj

[#2]

Hi Suraj,

this is depends  upon your requirement if you want only linking between two table then go with rupert solutions , but you you want booking table data related to invoice table then left join booking table with invoice table and apply some filter according to your requirement.