Part 7 of 8 listing all the fields in all the
tables of the dwh_ports Data Mart (OCI 7.3.4)
Part 1 of 8:
dwh_capacity
Part 2 of 8: dwh_capacity_efficiency
Part 3 of 8:
dwh_cloud_cost
~~~~~~~~~~~:
dwh_custom {skipped as custom}
Part 4 of 8:
dwh_fs_util
Part 5 of 8:
dwh_inventory
Part 6 of 8:
dwh_performance
Part 7 of 8:
dwh_ports
Part 8 of 8:
dwh_reports
Key = Database.Table.Field
dwh_ports.cardinals.digit
dwh_ports.connected_device_dimension.tk
dwh_ports.connected_device_dimension.name
dwh_ports.connected_device_dimension.manufacturer
dwh_ports.connected_device_dimension.model
dwh_ports.connected_device_dimension.type
dwh_ports.connected_device_dimension.firmware
dwh_ports.connected_device_dimension.id
dwh_ports.connected_device_dimension.latest
dwh_ports.date_dimension.tk
dwh_ports.date_dimension.fullDate
dwh_ports.date_dimension.dayInMonth
dwh_ports.date_dimension.dayInYear
dwh_ports.date_dimension.dateYear
dwh_ports.date_dimension.yearLabel
dwh_ports.date_dimension.monthNum
dwh_ports.date_dimension.monthLabel
dwh_ports.date_dimension.dayInWeekNum
dwh_ports.date_dimension.quarter
dwh_ports.date_dimension.quarterLabel
dwh_ports.date_dimension.dayInQuarter
dwh_ports.date_dimension.repQuarter
dwh_ports.date_dimension.repMonth
dwh_ports.date_dimension.repWeek
dwh_ports.date_dimension.repDay
dwh_ports.date_dimension.repMonthOrLatest
dwh_ports.date_dimension.sspFlag
dwh_ports.date_dimension.latest
dwh_ports.date_dimension.future
dwh_ports.port_dimension.tk
dwh_ports.port_dimension.wwn
dwh_ports.port_dimension.name
dwh_ports.port_dimension.gbicType
dwh_ports.port_dimension.type
dwh_ports.port_dimension.speed
dwh_ports.port_dimension.isGenerated
dwh_ports.port_dimension.url
dwh_ports.port_dimension.id
dwh_ports.port_dimension.latest
dwh_ports.port_dimension.dateTk
dwh_ports.ports_fact.tk
dwh_ports.ports_fact.dateTk
dwh_ports.ports_fact.switchTk
dwh_ports.ports_fact.connectedDeviceTk
dwh_ports.ports_fact.portTk
dwh_ports.ports_fact.fabric
dwh_ports.ports_fact.speed
dwh_ports.ports_fact.connectivityType
dwh_ports.ports_fact.type
dwh_ports.ports_fact.status
dwh_ports.ports_fact_current.tk
dwh_ports.ports_fact_current.dateTk
dwh_ports.ports_fact_current.switchTk
dwh_ports.ports_fact_current.connectedDeviceTk
dwh_ports.ports_fact_current.portTk
dwh_ports.ports_fact_current.fabric
dwh_ports.ports_fact_current.speed
dwh_ports.ports_fact_current.connectivityType
dwh_ports.ports_fact_current.type
dwh_ports.ports_fact_current.status
dwh_ports.switch_dimension.tk
dwh_ports.switch_dimension.wwn
dwh_ports.switch_dimension.name
dwh_ports.switch_dimension.identifier
dwh_ports.switch_dimension.ip
dwh_ports.switch_dimension.model
dwh_ports.switch_dimension.manufacturer
dwh_ports.switch_dimension.firmware
dwh_ports.switch_dimension.serialNumber
dwh_ports.switch_dimension.npv
dwh_ports.switch_dimension.isGenerated
dwh_ports.switch_dimension.type
dwh_ports.switch_dimension.url
dwh_ports.switch_dimension.id
dwh_ports.switch_dimension.latest
dwh_ports.switch_dimension.dateTk
dwh_ports.switch_dimension.dataCenter
dwh_ports.switch_dimension.switchLevel
Comments
Post a Comment