Informatica PowerCenter and General Technology Quiz

FTP stands for File Transfer Protocol, a standard network protocol used to transfer files between a client and server on a computer network. It's built on a client-server model architecture and separate control and data connections.

Oracle Corporation acquired Sun Microsystems in 2010 for approximately $7.4 billion. This acquisition gave Oracle control over Java, MySQL, and other Sun technologies. Apple and Microsoft are major tech companies but did not acquire Sun.

CERN httpd (also known as W3C httpd) was the first web server software, developed by Tim Berners-Lee at CERN in 1990. It ran on NeXTSTEP and was the foundation of the early World Wide Web. IIS came later, GWS is Google's server, and nginx is a modern server.

BCC stands for Blind Carbon Copy in email. It allows you to send copies to recipients without other recipients seeing who received the BCC. Unlike CC (Carbon Copy), BCC addresses are hidden from all other recipients.

James Gosling is widely recognized as the father of the Java programming language. He created the original design and implementation of Java at Sun Microsystems in the mid-1990s. Bill Smith, Jame Smith, and Sabeer Bhatia (Hotmail co-founder) are not associated with Java's creation.

ICANN (Internet Corporation for Assigned Names and Numbers) is the global coordinator of the Internet's unique identifier systems. However, no single entity 'owns' the Internet - it's a decentralized network. ICANN manages domain names and IP addresses but doesn't own the infrastructure.

NTFS (New Technology File System) is a proprietary file system developed by Microsoft. It was introduced with Windows NT and has been the default file system for Windows consumer versions since Windows XP. NTFS supports file-level security, compression, encryption, and large file sizes.

A cradle is a hardware device that holds and connects a portable device (like PDA, smartphone, or media player) to a desktop computer for synchronization, charging, and data transfer. The term comes from the device's cradle-like shape that securely holds the portable unit.

In Informatica PowerCenter, mapplets are reusable sets of transformations that can be used across multiple mappings. The Integration Service expands the mapplet at runtime, executing the transformations within it as part of the mapping flow.

When working with COBOL data sources in Informatica PowerCenter, you need the COBOL source definition to describe the file structure and a COBOL Source Qualifier to convert the complex COBOL data types into relational format that PowerCenter can process.

Mapping parameters and variables in ETL tools like Informatica allow mappings to work with different values without requiring design changes. Parameters are set before session execution, while variables can change during session execution, enabling flexible, reusable mapping designs.

The aggregation type property for mapping variables specifies how to compute the variable's final value when sessions run with multiple partitions. Common aggregation types include MAX, MIN, AVG, COUNT, which determine whether the variable holds the highest, lowest, average, or total value across all partitions.

Data Previewer works with any designer that defines data structures: sources in Source Analyzer, targets in Warehouse Designer, transformations in Mapping Designer, and mapplets in Mapplet Designer. It lets you sample data from these objects without running a full session.

Informatica's ROUND function handles both numeric and Date/Time types. For numeric types (Decimal, Double, etc.), it rounds to the specified precision. For Date/Time types, it rounds to the nearest date format (year, quarter, month, etc.).

Source Analyzer in Informatica can import or create multiple source types: relational tables/views/synonyms (a), COBOL files (c), XML files and data models (d). However, fixed-width and delimited flat files containing binary data (b) are NOT supported through Source Analyzer - binary data requires different handling. Therefore the correct combination is a, c, and d.

Tracing levels control logging granularity. Normal provides basic info, Terse gives minimal logging, Verbose Initialization logs startup details. Verbose Data writes a log entry for EVERY single row processed, which creates maximum overhead and significantly slows data loading performance. This level is typically used only for debugging specific row-level issues.

In Informatica mappings, parameters and variables have specific default values when not explicitly initialized. String parameters default to empty string (''), not null or '0'. Numeric parameters default to 0, not 1. This initialization behavior is important when designing conditional logic that checks for null versus empty values.

Fatal errors in Informatica are conditions that completely stop session execution. Key constraint violations (A) and loading nulls into not-null fields (B) are data-level errors but don't always halt execution - they may be redirected or handled based on session settings. Database trigger responses (C) depend on trigger logic. However, lack of database space (D) is a system-level failure that cannot be handled within the session - it's truly fatal.

The Informatica transformation language has reserved keywords that cannot be used as identifiers. TRUE, AND, and NULL are all reserved keywords with specific meanings. SUCCESS is not part of the reserved keyword set - it can be used as a user-defined variable name or column alias without conflict. This distinction matters when naming transformation ports or variables.