Header & details Table ?

[#1]

Hi All,

We are Having Various Header tables & Details Table..

HOw we Can Link them   ? On what we need to provide the Link..

Can any one Share the Document  related to this ...

Regards,

Helen

[sunny_talwar]

Not sure what you are looking to do. Would you be able to elaborate?

[#3]

Thanks..

In header table having 1 record, In details table having some 10 records related to that specific record in header table..

how to maintain the relation ?

[sunny_talwar]

If there is a unique key which connect the two tables, then the connection between the two tables can be made by making sure that both tables name the unique key with the same name.

HeaderTable:

LOAD CustomerID,

          CustomerName,

          CustomerAddress,

          ...

FROM Source1;

DetailTable:

LOAD TransactionNum,

          TransactionAmt,

          TransactionDate,

          CustomerID,

          ....

FROM Source2;

[maxgro]

You need one or more fields with the same name in the header and detail table

The logical key of the detail will be the logical key of the header and some other fields

Example

OrderHeader          OrderNo

OrderDetail             OrderNo + OrderLineNo