Scenario based

Denormalization is process of converting rows into columns. Understand how to implement the denormalization of data in Informatica Cloud (IICS) mapping and in Oracle using SQL.

Understand how to implement LEAD and LAG in Informatica Cloud and what scenario based questions can be built around this concept

Understand how to compare current and previous record in IICS mapping and what scenario based questions can be built around this concept

Understand when to introduce a dummy field in your IICS mapping and what scenario based interview questions can be built around this concept

Understand how to add sequence numbers to source data in IICS and what kind of scenario based interview questions can be built around this concept