Multiple Link

[rash_611]

Hi Team,

I have a concern while linking the table Kindly help me. Below is the table structure.

Asset Master -> Hostname, Asset Category, Domain, Location

Call Details-> Ticket ID, Open Date, Status, Close Date, Hostname

Monitoring -> Hostname, Metrics, Value, LogDate

LinkTable--> ID, Date

I want to link Asset Master, call details and Monitoring table through Hostname and want to Link OpenDate, LogDate to LinkTab to create the calender.

Kindly suggest how to do that since it is creating syn.Key or circular Link.

Regards,

Grace@

[tresesco]

Try like:

[Asset Master]:

Load

    Hostname,

     [Asset Category],

     Domain,

     Location

From <>;

[Call Details]:

Load

     Hostname,

     Hostname as HostLink,

     [Ticket ID],

     [Open Date],

     [Close Date],

     Status

From <>;

[Monitoring]:

Load

    Hostname as HostLink,

     Metrics,

     Value,

     LogDate as Date

From <>;

[DateTable]:

Load

     ID,

    Date

From <>;

[rash_611]

but i have to link the [Open Date] and [Close Date] also for Date for Calender purpose..

[tresesco]

For that you could take any(that fits your need) out of couple of approaches, like:

- create mutiple calendars for each date type

- create a link table for dates, see details here: Canonical Date

- create multiple date fields in one calendar table itself. May be like:

     Load

               Date,

               Date as [Open Date],

               Date as [Close Date]

     ...;