| Informatica Component | Equivalent Prophecy Gems |
|---|---|
| Aggregator | Aggregate |
| Teradata | Source/Target |
| Oracle | Source/Target |
| Flat File | Source/Target |
| Custom Transformation | Script |
| Expression | Reformat |
| External Procedure | Script |
| Filter | Filter |
| Input Transformation | Reformat |
| Joiner | Join |
| Lookup Procedure | Join |
| Maplet | Subgraph |
| Output Transformation | Reformat |
| Rank | Window Function |
| Router | Filter |
| Schema Transform | Schema Transform |
| Sequence | Schema Transform |
| Sort | Order By |
| Source Qualifier | Reformat |
| Stored Procedure | Script |
| Transaction Control | Target |
| Update Strategy | Target |
Informatica to Spark
Component mapping
List of supported Informatica components
For transpiling Informatica workflows to Prophecy pipelines, Transpiler first reads the uploaded files and then internally maps the Informatica components with Prophecy-supported gems to create the visual pipeline and open-source Spark code.
These Informatica components are core part of the workflow as they perform data operations like reading data from source table, performing transformations and writing data into the destination table.
Below is a list of all the Informatica components that are supported by Prophecy and the corresponding Prophecy gems:
If you are looking for a particular component and don’t see it on this list, fear not! Prophecy is extensible to allow inclusion of custom abilities way beyond custom scripting. Read this to learn more.