50 Informatica Interview Scenarios - Solved

Convert a single row into three rows in Informatica by turning columns into rows, using expression transformations and a normalizer.

Split non-key columns into two target tables keyed by the primary key, modeled with mapping design, expression transformation, and parameterized workflow execution.

Generate a sequence number with an Informatica expression transformation using a variable port and incremental logic, yielding 1, 2, 3, for each incoming record.

Learn how to separate duplicate and non-duplicate records from a source into two target tables using sort, expression, and router transformations.

Split records into three target tables using cyclic order of ten with a sequence generator and mod 30, routing the first ten, next ten, and last ten records in Informatica.

Concatenate duplicate values by comma in Informatica using a sorted input and an expression with a variable port, then use an aggregator to load the last record per group.

Discover how to compute a running salary with a cumulative sum in informatica, using q-function or variable port in an expression transformation on source and target data.

Shows how to generate a target table where each row stores the cumulative salary by adding the current salary to the previous row's salary, using an expression transformation with variables.

Generate file names at runtime using the system date by applying the to function on the state variable in an Informatica mapping; the mapping writes a dynamic flat file.

Remove the dollar symbol from the salary column using an expression transformation and replace string. Validate that the target data no longer shows the dollar prefix after the workflow runs.

Demonstrates an Informatica interview scenario for loading unique city distance records. Uses expression transformation to compare cities, an aggregator to compute max distance, and a session workflow.

demonstrates using a mapping parameter and a parameter file to drive a filter on department number, enabling dynamic loading for department 20 and easily switch to 30.

Send data one after another to three tables in cyclic order using a sequence generator and router. The caption demonstrates mod-based grouping and a three-way split across target tables.

Count vowels and consonants in the name column by using a mapping expression that replaces vowels with null, measures lengths, and derives consonants and vowels counts.

Remove special characters from employee numbers through a data cleansing mapping, using the replace STR function to replace unwanted chars with null and produce clean integer data.

Identify sla breaches by computing the delivery minus order date, select records with two or more days, and load missed-sla data to the target using an update strategy.

Calculate the hours difference between delivery date and order date using an expression in a data mapping workflow. The video guides importing source and target structures and parameterizing the workflow.

Explains how to add days to a date column in Informatica using add to date, converting day numbers into month and date, with a mapping, workflow, and parameterization.

Display records of employees who joined in the current month and year and load them into the target table using an update strategy transformation that inserts qualifying rows.

Extract first name, middle name, and last name from a single source field and map them into three target columns using expression transformation, substring, and in string in Informatica.

Convert numeric value to date format using an expression transformation, cast to date time after initial conversion, ensuring proper handling of numeric input formats in an Informatica mapping.

Design a mapping that checks hiredate format with is_date and to_date, converting valid strings to date and setting invalid records to null. The workflow demonstrates parameterization and successful etl execution.

Learn to separate header, detail, and footer from a flat file using Informatica, by designing a mapping with a sequence generator, aggregator, and router to split records.

Split duplicates from a dataset into unique and duplicate targets using sort, expression, and router in Informatica; also demonstrate routing all duplicates to one table and uniques to another.

Design an Informatica mapping to compute the previous row salary for each current row, returning null for the first row with an expression transformation and a variable port.

Design a mapping to display the next row salary for the current row from source to target, using expression transformations and a joyner transformation with master auto join for nulls.

Explore how to sum salaries and repeat the total on all rows using a designer mapping with aggregate sum, a dummy column, and a join in Informatica.

Design a mapping to load a target table with comma-separated values per ID, restarting the concatenation when the ID changes after sorting and using a variable and expression transformation.

Design a mapping to load all concatenated values from the source dataset into the target table, using a sorted transformation on id and an expression to build comma separated values.

design a mapping that concatenates values per ID column, using sort, expression transformation, and a group by aggregator to produce a target with ID and concatenated values.

Split a dataset into two target tables by numbering records with a sequence generator and routing the first half to one table, the second half to another.

Learn how to exclude the last five records from a flat-file source using sequence generation, aggregation, and filter techniques in an Informatica mapping.

Split odd and even records from a source into two target tables using an expression to generate a sequence and a router to route odd and even records.

Load data into the target table using a mapping parameter from the parameter file, filtering by department number 50 and parameterizing the mapping to load department specific records.

Generate an Oracle sequence through a SQL transformation using a sequence generator and expression transformation. Create and call the Oracle sequence to produce incremental values in a mapping.

Generate flat files dynamically at runtime by department number, using sort and expression transformations to set file names, manage transactions, and optionally write headers with field names.

Load data from three files (A1, A2, A3) into a single flat file using an indirect approach, ensuring no data loss and correct column handling.

Display first and last records from a source table into the same target table using a sequence generator, a filter for the first record, and an aggregator for the last.

Learn to extract the first and last records from a source using a single aggregator transformation, numbered with a sequence generator and using the first function.

Learn to replace dollar signs with rupees in the salary column from source to target tables by building an Informatica mapping using an expression transformation and the replace function.

Display the top three salary records without rank transformation by sorting salaries in descending order and filtering with a top three rule, using an expression transformation and a sequence generator.

Learn how to extract every fifth row from a source to a target using a sequence generator, an expression transformation, and a mod filter, producing four target rows.

Display the first three records from a flat file by using an expression transformation and a filter to select three rows, then output to the target file via a workflow.

Learn to display the last three records from a flat file in Informatica by sorting descending, generating a sequence, and filtering to three, via a mapped workflow.

This lecture demonstrates running the third workflow session only after the second session has run three times, using a persistent workflow variable and a mod function to gate execution.

Divide the source data into two halves by using a mapping variable to capture the count and pass it via a workflow variable to a second mapping that splits data.

Load data from a single source into three targets based on session.run, routing to tgt one, tgt two, or tgt three using a mapping variable.

Learn to create an email id by concatenating first name, last name, and organization name from source columns into a first.last@organization.com format, with initial caps for names.

Design a mapping to split an email id into first name, last name, organization, and domain using expression transformations and substring logic, then validate and load into the target.