You are not logged in.
Yes, you are on the right track, use a tOracleInput to query records from Oracle, do some transform on tMap if needed, and then load them into target database Greenplum with tGreenplumOutput.
I am working on Migrating the data from other databases like Oracle to the PostgreSQL Greenplum database in Job.
What I am thinking to do is using tOracleInput as input with a tMap and then tGreenplumOutput as output.
Any suggestions/tips on this?