HOW TO: Denormalize data in Informatica Cloud (IICS)?
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.
Scenario based
LEAD and LAG implementation in Informatica Cloud (IICS)
Understand how to implement LEAD and LAG in Informatica Cloud and what scenario based questions can be built around this concept
Comparing Current record with Previous record
Understand how to compare current and previous record in IICS mapping and what scenario based questions can be built around this concept
Introducing a dummy field in IICS Mapping
Understand when to introduce a dummy field in your IICS mapping and what scenario based interview questions can be built around this concept
Informatica Cloud (IICS) Scenario based Interview Questions
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