Informatica ICS component mapping

For transpiling Informatica Intelligent Cloud Services (IICS) mappings to Prophecy pipelines, Transpiler reads the exported IICS JSON and maps each transformation to a Prophecy-supported gem in a visual Spark pipeline.

IICS Transformation	Equivalent Prophecy Gem
Aggregator	Aggregate
Source (Database, Flat File, Cloud Application)	Source
Target	Target
Expression	Reformat
Filter	Filter
Joiner	Join
Lookup	Join
Rank	Window Function
Sorter	Order By
Router	Filter
Reusable Mapping	Subgraph
Update Strategy	Target
Sequence Generator	Schema Transform
Stored Procedure	Script
Command Task / HTTP Task	Script
Data Masking	Reformat
Transaction Control	Target
Data Preview / Metadata Update	Schema Transform
Taskflow (Orchestration)	Job

Migrate Informatica ICS to Spark

Ab Initio

Overview

Alteryx

Informatica

Ab Initio

DataStage