Network Protocol Port Numbers and Data Warehousing Concepts

Microsoft Remote Desktop Protocol (RDP) uses port 3389 as the default port for Terminal Server connections.

Microsoft SQL Server uses port 1433 as the default port for database connections. Port 1434 is used for the SQL Server Browser service.

Telnet protocol uses port 23 by default for unencrypted text-based remote terminal connections and command-line access.

LDAP uses port 389 as the default port for directory service operations. Port 636 is used for LDAPS (LDAP over SSL/TLS).

SMTP uses port 25 as the default port for email transmission between mail servers. This is the standard for mail routing.

HTTP uses port 80 as the default port for unencrypted web traffic. HTTPS (encrypted) uses port 443.

rlogin (remote login) is a Unix utility that uses port 513 for communication. Port 512 is used by rexec (remote execution), while ports 510 and 511 are not standard rlogin-related services. The correct answer is 513.

HTTPS (HTTP over SSL/TLS) uses port 443 as its well-known port. This is the standardized port for secure HTTP traffic. Port 444, 445, and 441 are used for other services (444 for SNPP, 445 for SMB over TCP).

IBM WebSphere MQ (formerly MQSeries) is a message-oriented middleware product. The default TCP port for queue manager communication is 1414. This is the standard port used for client connections to MQ queue managers.

Secure Shell (SSH) is a cryptographic network protocol for secure data communication. The standard TCP port for SSH is 22, used for secure logins, file transfers (scp, sftp), and port forwarding/tunneling.

Simple Network Management Protocol (SNMP) is used for network device management. SNMP agents listen on UDP port 161 for queries and commands from managers. SNMP traps (notifications) are sent to port 162.

traceroute is a network diagnostic tool that displays the route and measures transit delays of packets across an IP network. On Unix/Linux systems, traceroute typically starts sending UDP probes from port 33434, incrementing for each subsequent probe.

Domain Name System (DNS) resolves domain names to IP addresses. DNS uses both TCP and UDP on port 53. UDP is used for standard queries due to its low overhead, while TCP is used for zone transfers and larger responses.

Network Time Protocol (NTP) is used to synchronize computer clocks over packet-switched networks. NTP uses UDP port 123 for time synchronization between network devices. Accurate timekeeping is critical for authentication, logging, and distributed systems.

Conformed dimensions are dimensions that have the same meaning and content across multiple data marts. They enable integration of disparate data marts into a coherent data warehouse by ensuring consistent dimension keys and definitions. This allows drilling across data marts without data integrity issues.

Compound Growth Factor (CGF) measures how data volume grows over time in a data warehouse environment. As historical data accumulates and new sources are added, the data can explode exponentially. CGF quantifies this growth phenomenon, particularly relevant for storage capacity planning and performance management.

In dimensional modeling, fact tables link to dimension tables using surrogate keys - artificially generated keys that are independent of source system keys. Surrogate keys provide stability, performance, and handle slowly changing dimensions better than natural or compound keys.

Casual dimensions (also called degenerate dimensions) are dimension attributes stored in the fact table that have no corresponding dimension table. They explain why a fact exists - such as invoice number, order number, or transaction ID - and provide context without requiring a separate dimension table.

Factless fact tables contain no measures - only foreign keys to dimensions. They are used to track events or represent relationships that occur, such as student attendance, product promotions, or patient visits. The existence of a record indicates the event happened.