Skip to main content
When you migrate an Informatica workflow to a Prophecy pipeline, the transpiler first reads uploaded files. Then, the transpiler internally maps the Informatica components to the Prophecy-supported gems to create the visual pipeline and open-source code. Informatica components are a core part of the workflow. They perform data operations such as reading data from the source table, performing transformations, and writing data into the destination table. The following tables list all the Informatica components that Prophecy supports and the corresponding Prophecy gem it maps to in BigQuery SQL:
If you don’t see a particular component on this list, you can include custom abilities beyond custom scripting. To learn more, see Gem Builder for SQL.