What Oracle version do you use?

Do you run Oracle on premises or in a cloud-based Amazon RDS for Oracle environment?

What is the target type?

What type of load operation do you plan to perform: an initial load (point-in-time bulk load), incremental load (only the changes), or combined initial and incremental load (initial load followed by incremental load)?

What are the number of cores, memory, and disk space on the system where the Secure Agent will run?

What are the host name and port number of the Oracle source database server?

What is the Oracle system identifier (SID) for the database?

What are the Oracle database user name and password to use for connecting to the database?

Is the Oracle Database Client or Instant Client installed on the system where the Secure Agent will run?

Does the database run in an Oracle Real Application Cluster (RAC)? What's the maximum number of RAC members, including inactive nodes?

Do you need to capture change data from an Oracle Data Guard logical or physical standby database?

Do you need to capture change data from tables in a pluggable database (PDB) in an Oracle multitenant environment?

Do you need to capture change data from tablespaces that use Oracle Transparent Data Encryption (TDE)? If yes, what are the TDE wallet directory and password?

What is the typical size of units of work (UOWs) for the source tables?

Are the redo logs in an Oracle Automatic Storage Management (ASM) environment? If you plan to connect to an ASM instance to read redo logs, are you allowed to create a login user ID for ASM that has SYSDBA or SYSASM authority?

Are ARCHIVELOG mode and minimal global supplemental logging enabled for the Oracle source database? If not, can they be enabled?

What are the primary and secondary archive log destinations for the archived redo logs from which you want to read change data?

What is the average amount of archived redo log that is created per hour during peak and non-peak periods for the Oracle database?

Do you have read access to the redo logs in your environment?

If you do not have the authority to read the redo logs directly, can the archived redo log files be copied to shared disk or to a file system from which you can access them?

Do you want Mass Ingestion Databases to read change data from the online log as well as the archived logs?

Can you make your archived redo logs available for diagnostic use by Informatica Global Customer Support, if necessary, to diagnose an error or anomaly during CDC processing?

What is the schema name for the source tables from which to replicate data?

Do you want to replicate data from all tables in the schema or a subset of those tables? If a subset, create a list of them.

Do the source tables have primary keys? Can supplemental logging be enabled for all of the primary keys?

Do you have any unkeyed source tables?

Do the source tables contain columns that have unsupported data types? To determine which data types are not supported for your source types, see the source-specific topics under "Mass Ingestion Databases source considerations" in the Mass Ingestion help.

Is the default code page of UTF-8 acceptable? If not, which code page do you want to use?

Do you want to use SSL to encrypt data exchanged between the Secure Agent and database server? Which encryption SSL or TLS protocol do you use?

Are you allowed to create a new Oracle user and assign the privileges that Mass Ingestion Databases requires to that user? Determine the user name to use.

Do the source tables contain any Oracle data types that Mass Ingestion Databases does not support?

Do you want to capture schema drift changes on the source, including add, drop, modify, and rename column operations?