Technology and Informatica ETL Fundamentals

Informatica acquired Siperian in 2010 for $140 million to strengthen its Master Data Management (MDM) capabilities. 29West (acquired 2008) provided high-speed messaging technology, Agentlogic (acquired 2006) focused on complex event processing, and Velocity is not an Informatica acquisition.

In Informatica PowerCenter Repository Manager, the user who creates a folder automatically becomes its owner. This ownership model provides the creating user with full control permissions over the folder, including the ability to grant or revoke access rights for other users.

Repository backup operations are exclusively performed through Repository Manager in Informatica. Workflow Manager handles workflow design, execution scheduling, integration service assignments, and connection management, but repository-level administrative tasks like backup require the dedicated Repository Manager interface.

When no group-by ports are specified in an Aggregator transformation, Informatica treats all input rows as a single group and returns exactly one aggregated result row. The claim about returning the first row of each group is incorrect - there are no groups without group-by ports.

Placing filters near the source reduces data volume early in the pipeline, minimizing unnecessary processing and memory usage in downstream transformations. Filtering downstream means carrying irrelevant rows through multiple transformations, which significantly degrades mapping performance.

Variance is an aggregate statistical function that can only be used in Aggregator transformations in Informatica. Expression transformations support only single-row functions that operate on one row at a time, such as Substr, instr, and Add_to_date.

A master outer join in Joiner transformation keeps all rows from the MASTER source, not the detail source. This is the opposite of what option C states, making it the false statement that the question asks for. The other options are true: case-sensitive option exists for string comparisons, master outer join is generally faster than full/detail outer, and sorted input can improve joiner performance.

Unconnected Lookup is invoked from an expression in another transformation using :LKP qualification syntax (e.g., :LKP.lookup_name(condition)). It does not receive data through the normal data flow like connected lookups. This is the defining characteristic that makes it 'unconnected'.

Connected Lookup transformations in Informatica do support user-defined default values that are returned when no match is found. This is configured in the lookup transformation properties. The default value can be specified for each port in the lookup.

In Dynamic Lookup Cache, the Integration Service performs different actions based on the row type and cache configuration: it can insert new rows into the cache, update existing rows, or make no changes depending on whether the lookup is configured for insert/update or insert-only. All three actions are valid in different scenarios, making 'All of the above' correct.

The '@' symbol was selected by Ray Tomlinson in 1972 for use in email addresses to separate the user name from the host computer in the format user@host. This choice was made during the early development of email on ARPANET. The symbol was chosen because it was rarely used in names or other contexts at the time.

The first ARPANET message was sent in 1969 and was intended to be 'LOGIN'. However, the system crashed after typing 'LO', making 'lo' the first message that actually went through. This occurred during a test of the ARPANET connection between UCLA and Stanford Research Institute.

Intel's headquarters is located in Santa Clara, California, in the heart of Silicon Valley. This has been its corporate headquarters since the company was founded in 1968. Redmond is home to Microsoft, not Intel.

The .BAK extension is universally used for backup files across operating systems. When programs auto-save or create backups, they often use this extension. It indicates that the file is a backup copy of another file, typically with the same name but different extension.

The .MPG (or .MPEG) extension refers to video files - specifically MPEG (Moving Picture Experts Group) compressed video format. These are animation/movie files that use MPEG compression for efficient storage and transmission of video content.

The .INI extension stands for 'initialization' and is used for configuration files (system files) that store settings for applications and the Windows operating system. These plain text files contain key-value pairs that configure program behavior. They were especially common in older Windows versions.

The .JPG (or .JPEG) extension refers to image files using the JPEG (Joint Photographic Experts Group) compression format. This is one of the most common formats for photographic images on the web and digital devices due to its efficient compression.

The .BAT extension refers to batch files - system files that contain a sequence of commands for execution by the command-line interpreter in DOS and Windows. These are script files that automate tasks. They are called 'batch' files because they execute commands in a batch (sequence).

.MOV is a file extension used by Apple's QuickTime framework for multimedia files. It stores video, audio, and text in separate tracks, allowing for flexible editing and playback.