General Technology and Informatica ETL Fundamentals

devmgmt.msc is the correct Microsoft Management Console snap-in for Device Manager, allowing you to view and manage hardware devices. The 'mgmt' abbreviation is standard Windows naming convention, distinguishing it from similar-sounding but incorrect alternatives.

eventvwr.msc is the MMC snap-in for Event Viewer, where you can view system, application, and security event logs. Microsoft uses the 'vwr' abbreviation for viewer utilities, and Event Viewer is an MMC snap-in (.msc) not a Control Panel applet (.cpl).

msinfo32.exe is the Microsoft System Information tool that provides comprehensive OS and hardware information. While systeminfo.exe also exists (a command-line tool), msinfo32 is the GUI application specifically designed for detailed system information display.

In Informatica PowerCenter, the 'Case sensitive string comparison' option is specifically available and can be disabled in Relational lookup transformations. For Flatfile lookups, string comparison is always case-sensitive and this option does not exist. The question asks where the option is 'disabled' - meaning where it exists as a configurable option (which is only for Relational lookups).

Mapping parameters in Informatica have constant values throughout a session runtime - they are set before the session starts and do not change during execution. In contrast, mapping variables can change during session execution and the server saves their values for reuse. Parameters cannot be used in all transformations (there are restrictions), and their values cannot be changed using functions - they are set at session start.

SQL Transformation allows dynamic execution of SQL queries at runtime, making it ideal for updating target column values based on complex logic or lookups that can't be handled by standard transformations. Unlike Update Strategy which only flags records for insert/update/delete, SQL Transformation can execute actual UPDATE statements with dynamic conditions.

By default, Lookup transformation uses a static cache built at the beginning of the session and remains cached throughout. The cache is static (doesn't change during session) and cached (loaded into memory for faster access).

In Informatica lookup transformations, deleting unused lookup ports improves performance for relational sources by reducing data retrieval. For flat file lookup sources, the session fails if you delete ports because flat file lookups require all ports to match the source definition exactly. Option B is incorrect because relational lookups do not fail when ports are deleted.

When a dynamic lookup cache encounters multiple policy matches (multiple rows satisfying the lookup condition), the Integration Service fails the session because it cannot determine which row to use for caching. This is a deterministic behavior - the session does not continue with an arbitrary value. Dynamic caches require unique lookup conditions to function properly.

Windows+Pause/Break directly opens the System Properties window showing computer information. Other options are non-existent shortcuts for this purpose.

.xlh is not a standard Microsoft Excel file extension. The other options are all valid Excel formats - .xls (legacy workbook), .xlsx (modern XML-based workbook), and .xla (Excel add-in).

MAC addresses are 48-bit identifiers typically written as six hexadecimal pairs separated by hyphens or colons. Option B matches this format. Option A is an IPv4 address, C is IPv6, and D contains 'h' which is invalid in hex.

Multicast IP addresses fall in the range 224.0.0.0 to 239.255.255.255 (Class D). Option A (224.8.7.6) is within this range. B is APIPA (169.254.0.0/16), C is private Class A, and D is private Class B.

HTTP stands for HyperText Transfer Protocol, the foundation of data communication on the World Wide Web. Options A and C use incorrect words, and B says 'Transport' instead of 'Transfer'.