Details: Informix database needs a colon(:) as the catalog delimiter for a fully qualified table name, i.e., salesdb:contacts. How to specify such tables in Oracle GoldenGate parameter file?
Answer: Oracle GoldenGate for Informix requires user to use "." for fully qualified names, e.g. database_name.schema_name.table_name. For the example table, you can use salesdb.contacts. If there is a first_name column in the contacts table, you can use the following syntax: salesdb.contacts.first_name.
Answer: Oracle GoldenGate for Informix requires user to use "." for fully qualified names, e.g. database_name.schema_name.table_name. For the example table, you can use salesdb.contacts. If there is a first_name column in the contacts table, you can use the following syntax: salesdb.contacts.first_name.