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:
Informatica ComponentEquivalent Prophecy Gems
AggregatorAggregate
TeradataTable
OracleSource/Target
Flat FileSource/Target
ExpressionReformat
FilterFilter
Input TransformationReformat
JoinerJoin
Lookup ProcedureJoin
Output TransformationReformat
RankWindow Function
RouterFilter
Schema TransformReformat
SequenceReformat
SortOrder By
Source QualifierReformat
Transaction ControlTarget
Update StrategyTarget
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.