> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Informatica ICS 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.

| IICS Transformation                                 | Equivalent Prophecy Gem                                               |
| --------------------------------------------------- | --------------------------------------------------------------------- |
| **Aggregator**                                      | [Aggregate](/data-engineering/gems/transform/aggregate)               |
| **Source (Database, Flat File, Cloud Application)** | [Source](/data-engineering/gems/source-target/)                       |
| **Target**                                          | [Target](/data-engineering/gems/source-target/)                       |
| **Expression**                                      | [Reformat](/data-engineering/gems/transform/reformat)                 |
| **Filter**                                          | [Filter](/data-engineering/gems/transform/filter)                     |
| **Joiner**                                          | [Join](/data-engineering/gems/join-split/join)                        |
| **Lookup**                                          | [Join](/data-engineering/gems/join-split/join)                        |
| **Rank**                                            | [Window Function](/data-engineering/gems/transform/window-function)   |
| **Sorter**                                          | [Order By](/data-engineering/gems/transform/order-by)                 |
| **Router**                                          | [Filter](/data-engineering/gems/transform/filter)                     |
| **Reusable Mapping**                                | [Subgraph](/data-engineering/gems/subgraph/subgraph)                  |
| **Update Strategy**                                 | [Target](/data-engineering/gems/source-target/)                       |
| **Sequence Generator**                              | [Schema Transform](/data-engineering/gems/transform/schema-transform) |
| **Stored Procedure**                                | [Script](/data-engineering/gems/custom/script)                        |
| **Command Task / HTTP Task**                        | [Script](/data-engineering/gems/custom/script)                        |
| **Data Masking**                                    | [Reformat](/data-engineering/gems/transform/reformat)                 |
| **Transaction Control**                             | [Target](/data-engineering/gems/source-target/)                       |
| **Data Preview / Metadata Update**                  | [Schema Transform](/data-engineering/gems/transform/schema-transform) |
| **Taskflow (Orchestration)**                        | [Job](/data-engineering/orchestration/databricks-jobs)                |