| 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 |
Informatica ICS to SQL
Component mapping
List of supported Informatica Intelligent Cloud Services (IICS) components and their equivalent Prophecy gems
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.