Administrator
- Administrator
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
{ "totalCount": 1, "pageNo": 0, "pageSize": 25, "documents": [ { "taskId": 746231, "name": "sf_to_snowflake_full", "documentState": "VALID", "documentType": "APPMI_TASK", "parentInfo": [ { "parentId": "7cCn5thwWFLhiZoSosphKL", "parentName": "REG", "parentType": "Space" }, { "parentId": "3uDIOqah80qbMK3cXAceIp", "parentName": "Default", "parentType": "Project" } ], "description": "", "owner": "6r2IItttmU3ibDwPqxnRwb", "createdBy": "6r2IItttmU3ibDwPqxnRwb", "createdTime": "2026-09-24T05:46:27.000+00:00", "accessedTime": "2026-09-24T05:47:24.306+00:00", "updateTime": "2026-09-24T05:47:24.306+00:00", "dbmiTask": { "type": "appmi", "general": { "name": "sf_to_snowflake_full", "description": null, "location": "Default", "runtimeEnvironment": "invyaminirh01.informatica.com", "type": "initial" }, "source": { "connection": "AIN_Salesforce", "customProperties": { "salesforce.bulkv2.enable.partitioning": "true", "salesforce.bulkv2.max.parallel.partitions": "5", "salesforce.bulkv2.records.per.partition": "10000", "selectionMode": "RULE_BASED", "ai.fetch.size": "50000", "ai.salesforce.unload.api.type": "bulkv2" }, "restartPointForIncrementalLoadTimestamp": null, "schema": "SALESFORCE", "includeViews": null, "replicationSlotName": null, "replicationPlugin": null, "publication": null, "journalName": null, "restartPointForIncrementalLoad": null, "restartPointForIncrementalLoadPosition": null, "cdcTechnique": null, "cdcQueryBasedColumnType": null, "cdcQueryBasedColumnName": null, "cdcQueryBasedDateColumn": null, "cdcQueryBasedTimeColumn": null, "context": null, "accountId": null, "propertyId": null, "viewId": null, "pathToReportConfigurationFile": null, "product": null, "services": null, "outputType": null, "salesforceAPI": "bulkv2", "fetchSize": "50000", "fetchSizeForInitialLoad": null, "fetchSizeForIncrementalLoad": null, "startDate": null, "endDate": null, "cdcIntervalDays": null, "cdcIntervalHours": null, "cdcIntervalMins": null, "extractNonDefaultFields": null, "includeArchivedAndDeletedRows": null, "includeBase64Fields": null, "maximumBase64BodySize": null, "batchSize": null, "mid": null, "readerInputIsPersisted": null, "readerHistoricalCacheUseCloud": null, "lobsEnabled": null, "unloadFlashbackDisabled": null, "enableAlternateSource": null, "alternateSourceId": null, "cdcStagingMigration": null, "cdcStagingMigrationTasks": null, "jdbcPartitioningTechnique": null, "sourceMaxParallelPartitions": null, "unloadHelperThreadCount": null, "readEventBatchSize": null, "readerHelperThreadCount": null, "salesforceBulkV2Partitioning": "true", "salesforceBulkV2RecordsPerPartition": "10000", "salesforceBulkV2MaxParallelPartitions": "5", "workdayReplicationType": null, "workdayReportsNumber": null, "workdayReportName": null, "workdayReportsConfigFile": null, "oracleFusionInterfaceType": null, "oracleFusionModuleName": null, "oracleFusionEnableChildObjects": null, "formattedStartDate": "", "formattedEndDate": "", "selectionRules": [ { "include": "Custom_all__c" } ] }, "target": { "connection": "Snowflake_pat_sp", "schema": "INFORMATION_SCHEMA", "outputFormat": "CSV", "fileCompressionType": "None", "parquetFormat": "true", "fixedDirectoryForEachTable": "false", "renamingRules": [], "dataTypeRules": [], "stage": "gkn", "bucket": "", "directory": "", "addBeforeImages": "false", "useTableNameAsTopicName": "false", "includeSchemaName": "false", "asyncWrite": "true", "writerSnowflakeIngestionMethod": "", "customProperties": { "targetIdentifiersEnableCaseTransformation": "false", "auditColumnsPrefix": "INFA_", "targetBucket": "", "targetDirectory": "", "writerSnowflakeIngestionMethod": "" } }, "runtimeOptions": { "numberOfRowsInOutputFile": null, "fileExtensionBasedOnFileType": null, "applyCycleChangeLimit": null, "applyCycleIntervalDays": null, "applyCycleIntervalHours": null, "applyCycleIntervalMins": null, "applyCycleIntervalSecs": null, "lowActivityFlushHours": null, "lowActivityFlushMins": null, "checkpointAllRows": null, "checkpointEveryCommit": null, "checkpointRowCount": null, "checkpointFrequencySecs": null, "executeInTaskflow": false, "enableAutoTuning": false, "schemaDriftOptions": null, "customProperties": {} }, "replicationRules": { "source": "SALESFORCE", "target": "INFORMATION_SCHEMA", "overrides": { "tableRules": [], "fieldRules": [] }, "sourceSet": [ { "schema": "", "include": "Custom_all__c" } ], "columnTransformations": [] } } } ] }
{ "totalCount": 1, "pageNo": 0, "pageSize": 25, "documents": [ { "taskId": 759323, "name": "sf_to_snowflake_incremental_full", "documentState": "VALID", "documentType": "APPMI_TASK", "parentInfo": [ { "parentId": "7cCn5thwWFLhiZoSosphKL", "parentName": "REG", "parentType": "Space" }, { "parentId": "3uDIOqah80qbMK3cXAceIp", "parentName": "Default", "parentType": "Project" } ], "description": "", "owner": "6r2IItttmU3ibDwPqxnRwb", "createdBy": "6r2IItttmU3ibDwPqxnRwb", "createdTime": "2026-10-12T10:27:41.000+00:00", "accessedTime": "2026-10-12T10:28:23.296+00:00", "updateTime": "2026-10-12T10:28:23.296+00:00", "dbmiTask": { "type": "appmi", "general": { "name": "sales_cdc_check_case1_oct12", "description": null, "location": "Default", "runtimeEnvironment": "invyaminirh01.informatica.com", "type": "cdc" }, "source": { "connection": "AIN_Salesforce", "customProperties": { "selectionMode": "RULE_BASED", "ai.fetch.size": "2000", "ai.cdc.interval.mins": "5" }, "restartPointForIncrementalLoadTimestamp": "2026-10-12 10:25:56 AM", "schema": "SALESFORCE", "includeViews": null, "replicationSlotName": null, "replicationPlugin": null, "publication": null, "journalName": null, "restartPointForIncrementalLoad": null, "restartPointForIncrementalLoadPosition": null, "cdcTechnique": null, "cdcQueryBasedColumnType": null, "cdcQueryBasedColumnName": null, "cdcQueryBasedDateColumn": null, "cdcQueryBasedTimeColumn": null, "context": null, "accountId": null, "propertyId": null, "viewId": null, "pathToReportConfigurationFile": null, "product": null, "services": null, "outputType": null, "salesforceAPI": null, "fetchSize": "2000", "fetchSizeForInitialLoad": null, "fetchSizeForIncrementalLoad": null, "startDate": null, "endDate": null, "cdcIntervalDays": null, "cdcIntervalHours": null, "cdcIntervalMins": "5", "extractNonDefaultFields": null, "includeArchivedAndDeletedRows": null, "includeBase64Fields": null, "maximumBase64BodySize": null, "batchSize": null, "mid": null, "readerInputIsPersisted": null, "readerHistoricalCacheUseCloud": null, "lobsEnabled": null, "unloadFlashbackDisabled": null, "enableAlternateSource": null, "alternateSourceId": null, "cdcStagingMigration": null, "cdcStagingMigrationTasks": null, "jdbcPartitioningTechnique": null, "sourceMaxParallelPartitions": null, "unloadHelperThreadCount": null, "readEventBatchSize": null, "readerHelperThreadCount": null, "salesforceBulkV2Partitioning": null, "salesforceBulkV2RecordsPerPartition": null, "salesforceBulkV2MaxParallelPartitions": null, "workdayReplicationType": null, "workdayReportsNumber": null, "workdayReportName": null, "workdayReportsConfigFile": null, "oracleFusionInterfaceType": null, "oracleFusionModuleName": null, "oracleFusionEnableChildObjects": null, "formattedStartDate": "", "formattedEndDate": "", "selectionRules": [ { "include": "Period" } ] }, "target": { "connection": "Snowflake_pat_sp", "schema": "SNOW_PB", "outputFormat": "CSV", "fileCompressionType": "None", "parquetFormat": "true", "fixedDirectoryForEachTable": "false", "renamingRules": [ { "source": "Period", "target": "Period_O12A" } ], "dataTypeRules": [], "stage": "gkn", "bucket": "", "directory": "", "addBeforeImages": "false", "directoryTags": "", "useTableNameAsTopicName": "false", "includeSchemaName": "false", "asyncWrite": "true", "writerSnowflakeIngestionMethod": "", "writerSnowflakeDeferredMergeInterval": "3600", "addLastReplicatedTime": "false", "cycleId": "false", "customProperties": { "targetDirectory": "", "rat.cdcfile.target.directory": "", "writerSnowflakeIngestionMethod": "", "targetIdentifiersEnableCaseTransformation": "true", "rat.audit.columns.optype": "false", "targetIdentifiersCaseConversionStrategy": "NO_TRANSFORMATION", "rat.target.columns.last.replicated.time": "false", "applyMode": "standard", "targetBucket": "", "writerSnowflakeDeferredMergeInterval": "3600", "auditColumnsPrefix": "INFA_", "rat.target.columns.cycleId": "false" }, "caseTransformation": "none" }, "runtimeOptions": { "numberOfRowsInOutputFile": null, "fileExtensionBasedOnFileType": null, "applyCycleChangeLimit": null, "applyCycleIntervalDays": null, "applyCycleIntervalHours": null, "applyCycleIntervalMins": null, "applyCycleIntervalSecs": null, "lowActivityFlushHours": null, "lowActivityFlushMins": null, "checkpointAllRows": null, "checkpointEveryCommit": null, "checkpointRowCount": null, "checkpointFrequencySecs": null, "executeInTaskflow": false, "enableAutoTuning": false, "schemaDriftOptions": { "modifyField": "replicate", "dropField": "ignore", "addField": "replicate", "renameField": "ignore" }, "customProperties": {} }, "replicationRules": { "source": "SALESFORCE", "target": "SNOW_PB", "overrides": { "tableRules": [ { "source": "Period", "target": "Period_O12A" } ], "fieldRules": [] }, "sourceSet": [ { "schema": "", "include": "Period" } ], "columnTransformations": [] } } } ] }
{ "totalCount": 1, "pageNo": 0, "pageSize": 25, "documents": [ { "taskId": 746431, "name": "sf_to_snowflake_combined", "documentState": "VALID", "documentType": "APPMI_TASK", "parentInfo": [ { "parentId": "7cCn5thwWFLhiZoSosphKL", "parentName": "REG", "parentType": "Space" }, { "parentId": "33YxQayEoi1d5QgU02OQGV", "parentName": "Oracle", "parentType": "Project" } ], "description": "this is task created from api for combined", "owner": "6r2IItttmU3ibDwPqxnRwb", "createdBy": "6r2IItttmU3ibDwPqxnRwb", "createdTime": "2026-09-24T11:34:37.000+00:00", "accessedTime": "2026-10-07T07:05:27.328+00:00", "updateTime": "2026-10-07T07:05:27.328+00:00", "dbmiTask": { "type": "appmi", "general": { "name": "sf_to_snowflake_combined", "description": null, "location": "Oracle", "runtimeEnvironment": "invyaminirh01.informatica.com", "type": "combined" }, "source": { "connection": "AIN_Salesforce", "customProperties": { "salesforce.bulkv2.enable.partitioning": "true", "ai.cdc.interval.hours": "0", "ai.fetch.size.cdc": "2000", "ai.cdc.interval.days": "0", "salesforce.bulkv2.max.parallel.partitions": "5", "salesforce.bulkv2.records.per.partition": "2000", "ai.cdc.interval.mins": "5", "ai.unload.fetch.deleted.archived.data": "false", "ai.fetch.size": "50000", "ai.salesforce.unload.api.type": "bulkv2" }, "restartPointForIncrementalLoadTimestamp": null, "schema": "SALESFORCE", "includeViews": null, "replicationSlotName": null, "replicationPlugin": null, "publication": null, "journalName": null, "restartPointForIncrementalLoad": "LATEST", "restartPointForIncrementalLoadPosition": null, "cdcTechnique": null, "cdcQueryBasedColumnType": null, "cdcQueryBasedColumnName": null, "cdcQueryBasedDateColumn": null, "cdcQueryBasedTimeColumn": null, "context": null, "accountId": null, "propertyId": null, "viewId": null, "pathToReportConfigurationFile": null, "product": null, "services": null, "outputType": null, "salesforceAPI": "bulkv2", "fetchSize": "50000", "fetchSizeForInitialLoad": null, "fetchSizeForIncrementalLoad": "2000", "startDate": null, "endDate": null, "cdcIntervalDays": "0", "cdcIntervalHours": "0", "cdcIntervalMins": "5", "extractNonDefaultFields": null, "includeArchivedAndDeletedRows": "false", "includeBase64Fields": null, "maximumBase64BodySize": null, "batchSize": null, "mid": null, "readerInputIsPersisted": null, "readerHistoricalCacheUseCloud": null, "lobsEnabled": null, "unloadFlashbackDisabled": null, "enableAlternateSource": null, "alternateSourceId": null, "cdcStagingMigration": null, "cdcStagingMigrationTasks": null, "jdbcPartitioningTechnique": null, "sourceMaxParallelPartitions": null, "unloadHelperThreadCount": null, "readEventBatchSize": null, "readerHelperThreadCount": null, "salesforceBulkV2Partitioning": "true", "salesforceBulkV2RecordsPerPartition": "2000", "salesforceBulkV2MaxParallelPartitions": "5", "workdayReplicationType": null, "workdayReportsNumber": null, "workdayReportName": null, "workdayReportsConfigFile": null, "oracleFusionInterfaceType": null, "oracleFusionModuleName": null, "oracleFusionEnableChildObjects": null, "formattedStartDate": "", "formattedEndDate": "", "selectionRules": [ { "include": "cli_sf__c" }, { "exclude": "Period" } ] }, "target": { "connection": "Snowflake_pat_sp", "schema": "ADOBE_PB", "outputFormat": "CSV", "fileCompressionType": "None", "parquetFormat": "false", "avroFormat": "Avro-Generic", "avroSerializationFormat": "BINARY", "fixedDirectoryForEachTable": "true", "avroCompressionType": "None", "parquetCompressionType": "None", "deflateCompressionLevel": "1", "renamingRules": [ { "source": "cli_sf__c", "target": "cli_sf__c3" } ], "dataTypeRules": [], "stage": "gkn", "addBeforeImages": "false", "useTableNameAsTopicName": "false", "includeSchemaName": "true", "asyncWrite": "true", "customProperties": { "targetIdentifiersEnableCaseTransformation": "false" } }, "runtimeOptions": { "numberOfRowsInOutputFile": null, "fileExtensionBasedOnFileType": null, "applyCycleChangeLimit": null, "applyCycleIntervalDays": null, "applyCycleIntervalHours": null, "applyCycleIntervalMins": null, "applyCycleIntervalSecs": null, "lowActivityFlushHours": null, "lowActivityFlushMins": null, "checkpointAllRows": null, "checkpointEveryCommit": null, "checkpointRowCount": null, "checkpointFrequencySecs": null, "executeInTaskflow": false, "enableAutoTuning": false, "schemaDriftOptions": { "modifyField": "replicate", "dropField": "ignore", "addField": "ignore", "renameField": "replicate" }, "customProperties": { "writerRecoveryEnableCycleUpdates": "false", "enableAutoTuning": "false" } }, "replicationRules": { "source": "SALESFORCE", "target": "ADOBE_PB", "overrides": { "tableRules": [ { "source": "cli_sf__c", "target": "cli_sf__c3" } ], "fieldRules": [] }, "sourceSet": [ { "schema": "", "include": "cli_sf__c" }, { "schema": "", "exclude": "Period" } ], "columnTransformations": [] } } } ] }
{ "totalCount": 1, "pageNo": 0, "pageSize": 25, "documents": [ { "taskId": 757385, "name": "oracle_to_snowflake_full", "documentState": "VALID", "documentType": "DBMI_TASK", "parentInfo": [ { "parentId": "7cCn5thwWFLhiZoSosphKL", "parentName": "REG", "parentType": "Space" }, { "parentId": "3uDIOqah80qbMK3cXAceIp", "parentName": "Default", "parentType": "Project" } ], "description": "oracle unload sample", "owner": "6r2IItttmU3ibDwPqxnRwb", "createdBy": "6r2IItttmU3ibDwPqxnRwb", "createdTime": "2026-10-08T06:41:11.000+00:00", "accessedTime": "2026-10-08T06:46:54.541+00:00", "updateTime": "2026-10-08T06:46:54.541+00:00", "dbmiTask": { "type": "dbmi", "general": { "name": "oracle_to_snowflake_full", "description": null, "location": "Default", "runtimeEnvironment": "invyaminirh01.informatica.com", "type": "initial" }, "source": { "connection": "Oracle_19RDS_yk-CDC", "customProperties": { "lobsEnabled": "true", "unloadFlashbackDisabled": "true", "unloadJdbcPartitioningTechnique": "uniform", "unloadSourceMaxParallelPartitions": "5", "unloadHelperThreadCount": "2" }, "restartPointForIncrementalLoadTimestamp": null, "schema": "AUTO_INIT", "includeViews": null, "replicationSlotName": null, "replicationPlugin": null, "publication": null, "journalName": null, "restartPointForIncrementalLoad": null, "restartPointForIncrementalLoadPosition": null, "cdcTechnique": null, "cdcQueryBasedColumnType": null, "cdcQueryBasedColumnName": null, "cdcQueryBasedDateColumn": null, "cdcQueryBasedTimeColumn": null, "context": null, "accountId": null, "propertyId": null, "viewId": null, "pathToReportConfigurationFile": null, "product": null, "services": null, "outputType": null, "salesforceAPI": null, "fetchSize": null, "fetchSizeForInitialLoad": null, "fetchSizeForIncrementalLoad": null, "startDate": null, "endDate": null, "cdcIntervalDays": null, "cdcIntervalHours": null, "cdcIntervalMins": null, "extractNonDefaultFields": null, "includeArchivedAndDeletedRows": null, "includeBase64Fields": null, "maximumBase64BodySize": null, "batchSize": null, "mid": null, "readerInputIsPersisted": null, "readerHistoricalCacheUseCloud": null, "lobsEnabled": "true", "unloadFlashbackDisabled": "true", "enableAlternateSource": null, "alternateSourceId": null, "cdcStagingMigration": null, "cdcStagingMigrationTasks": null, "jdbcPartitioningTechnique": "uniform", "sourceMaxParallelPartitions": "5", "unloadHelperThreadCount": "2", "readEventBatchSize": null, "readerHelperThreadCount": null, "salesforceBulkV2Partitioning": null, "salesforceBulkV2RecordsPerPartition": null, "salesforceBulkV2MaxParallelPartitions": null, "workdayReplicationType": null, "workdayReportsNumber": null, "workdayReportName": null, "workdayReportsConfigFile": null, "oracleFusionInterfaceType": null, "oracleFusionModuleName": null, "oracleFusionEnableChildObjects": null, "formattedStartDate": "", "formattedEndDate": "", "selectionRules": [ { "include": "SRC_ALLCHAR_8K", "fieldsSet": [ { "exclude": "VARCHARMAX" } ] } ] }, "target": { "connection": "Snowflake_pat_sp", "schema": "ADOBE_PB", "outputFormat": "CSV", "fileCompressionType": "None", "parquetFormat": "false", "avroFormat": "Avro-Generic", "avroSerializationFormat": "BINARY", "fixedDirectoryForEachTable": "true", "avroCompressionType": "None", "parquetCompressionType": "None", "deflateCompressionLevel": "1", "renamingRules": [], "dataTypeRules": [], "stage": "gkn", "addBeforeImages": "false", "useTableNameAsTopicName": "false", "includeSchemaName": "true", "asyncWrite": "true", "addLastReplicatedTime": "true", "cycleId": "false", "customProperties": { "targetIdentifiersCaseConversionStrategy": "TO_LOWERCASE", "rat.target.columns.last.replicated.time": "true", "targetIdentifiersEnableCaseTransformation": "true", "rat.target.columns.cycleId": "false" }, "caseTransformation": "lowercase" }, "runtimeOptions": { "numberOfRowsInOutputFile": null, "fileExtensionBasedOnFileType": null, "applyCycleChangeLimit": null, "applyCycleIntervalDays": null, "applyCycleIntervalHours": null, "applyCycleIntervalMins": null, "applyCycleIntervalSecs": null, "lowActivityFlushHours": null, "lowActivityFlushMins": null, "checkpointAllRows": null, "checkpointEveryCommit": null, "checkpointRowCount": null, "checkpointFrequencySecs": null, "executeInTaskflow": false, "enableAutoTuning": false, "schemaDriftOptions": null, "customProperties": { "writerRecoveryEnableCycleUpdates": "false", "enableAutoTuning": "false" } }, "replicationRules": { "source": "AUTO_INIT", "target": "ADOBE_PB", "overrides": { "tableRules": [], "fieldRules": [] }, "sourceSet": [ { "fieldsSet": [ { "exclude": "VARCHARMAX" } ], "schema": "", "include": "SRC_ALLCHAR_8K" } ], "columnTransformations": [] } } } ] }
{ "totalCount": 1, "pageNo": 0, "pageSize": 25, "documents": [ { "taskId": 757659, "name": "oracle_to_snowflake_cdc", "documentState": "VALID", "documentType": "DBMI_TASK", "parentInfo": [ { "parentId": "7cCn5thwWFLhiZoSosphKL", "parentName": "REG", "parentType": "Space" }, { "parentId": "3uDIOqah80qbMK3cXAceIp", "parentName": "Default", "parentType": "Project" } ], "description": "", "owner": "6r2IItttmU3ibDwPqxnRwb", "createdBy": "6r2IItttmU3ibDwPqxnRwb", "createdTime": "2026-10-08T11:42:11.000+00:00", "accessedTime": "2026-10-08T11:51:21.259+00:00", "updateTime": "2026-10-08T11:51:21.259+00:00", "dbmiTask": { "type": "dbmi", "general": { "name": "oracle_to_snowflake_cdc", "description": null, "location": "Default", "runtimeEnvironment": "invyaminirh01.informatica.com", "type": "cdc" }, "source": { "connection": "Oracle_19RDS_yk-CDC", "customProperties": { "loadType": "CDC", "journalName": "", "dbmi.cdc.query.based.column.type": "COLUMN_TYPE_TIMESTAMP", "pwx.cdcreader.postgresql.connection.repl.publication": "", "readEventBatchSize": "32", "dbmi.cdc.interval.mins": "5", "dbmi.cdc.query.based.column.name": "QUERY_BASED_COL", "dbmi.cdc.interval.hours": "0", "readerInputIsPersisted": "false", "readerHelperThreadCount": "3", "dbmi.cdc.technique": "QUERY_BASED_CDC", "pwx.cdcreader.postgresql.connection.repl.slotname": "", "lobsEnabled": "false", "dbmi.cdc.interval.days": "0", "selectionMode": "RULE_BASED" }, "restartPointForIncrementalLoadTimestamp": null, "schema": "QUERYBASEDCDC", "includeViews": null, "replicationSlotName": "", "replicationPlugin": null, "publication": "", "journalName": "", "restartPointForIncrementalLoad": "LATEST", "restartPointForIncrementalLoadPosition": null, "cdcTechnique": "QUERY_BASED_CDC", "cdcQueryBasedColumnType": "COLUMN_TYPE_TIMESTAMP", "cdcQueryBasedColumnName": "QUERY_BASED_COL", "cdcQueryBasedDateColumn": null, "cdcQueryBasedTimeColumn": null, "context": null, "accountId": null, "propertyId": null, "viewId": null, "pathToReportConfigurationFile": null, "product": null, "services": null, "outputType": null, "salesforceAPI": null, "fetchSize": null, "fetchSizeForInitialLoad": null, "fetchSizeForIncrementalLoad": null, "startDate": null, "endDate": null, "cdcIntervalDays": "0", "cdcIntervalHours": "0", "cdcIntervalMins": "5", "extractNonDefaultFields": null, "includeArchivedAndDeletedRows": null, "includeBase64Fields": null, "maximumBase64BodySize": null, "batchSize": null, "mid": null, "readerInputIsPersisted": "false", "readerHistoricalCacheUseCloud": null, "lobsEnabled": "false", "unloadFlashbackDisabled": null, "enableAlternateSource": null, "alternateSourceId": null, "cdcStagingMigration": null, "cdcStagingMigrationTasks": null, "jdbcPartitioningTechnique": null, "sourceMaxParallelPartitions": null, "unloadHelperThreadCount": null, "readEventBatchSize": "32", "readerHelperThreadCount": "3", "salesforceBulkV2Partitioning": null, "salesforceBulkV2RecordsPerPartition": null, "salesforceBulkV2MaxParallelPartitions": null, "workdayReplicationType": null, "workdayReportsNumber": null, "workdayReportName": null, "workdayReportsConfigFile": null, "oracleFusionInterfaceType": null, "oracleFusionModuleName": null, "oracleFusionEnableChildObjects": null, "formattedStartDate": "", "formattedEndDate": "", "selectionRules": [ { "include": "SRC_ALLNUM_8K" } ] }, "target": { "connection": "Snowflake_pat_sp", "schema": "SNOW_PB", "outputFormat": "CSV", "fileCompressionType": "None", "parquetFormat": "true", "fixedDirectoryForEachTable": "false", "renamingRules": [ { "source": "SRC_ALLNUM_8K", "target": "NUM_SPIPE2" } ], "dataTypeRules": [], "stage": "gkn", "bucket": "", "directory": "", "addBeforeImages": "false", "directoryTags": "", "useTableNameAsTopicName": "false", "includeSchemaName": "false", "asyncWrite": "true", "writerSnowflakeIngestionMethod": "", "writerSnowflakeDeferredMergeInterval": "3600", "addLastReplicatedTime": "false", "cycleId": "false", "customProperties": { "targetDirectory": "", "rat.cdcfile.target.directory": "", "writerSnowflakeIngestionMethod": "", "targetIdentifiersEnableCaseTransformation": "true", "rat.audit.columns.optype": "false", "targetIdentifiersCaseConversionStrategy": "NO_TRANSFORMATION", "rat.target.columns.last.replicated.time": "false", "applyMode": "standard", "targetBucket": "", "writerSnowflakeDeferredMergeInterval": "3600", "auditColumnsPrefix": "INFA_", "rat.target.columns.cycleId": "false" }, "caseTransformation": "none" }, "runtimeOptions": { "numberOfRowsInOutputFile": null, "fileExtensionBasedOnFileType": null, "applyCycleChangeLimit": null, "applyCycleIntervalDays": null, "applyCycleIntervalHours": null, "applyCycleIntervalMins": null, "applyCycleIntervalSecs": null, "lowActivityFlushHours": null, "lowActivityFlushMins": null, "checkpointAllRows": null, "checkpointEveryCommit": null, "checkpointRowCount": null, "checkpointFrequencySecs": null, "executeInTaskflow": false, "enableAutoTuning": false, "schemaDriftOptions": { "addColumn": "replicate", "renameColumn": "ignore", "modifyColumn": "replicate", "dropColumn": "ignore" }, "customProperties": { "writerRecoveryEnableCycleUpdates": "false", "enableAutoTuning": "false" } }, "replicationRules": { "source": "QUERYBASEDCDC", "target": "SNOW_PB", "overrides": { "tableRules": [ { "source": "SRC_ALLNUM_8K", "target": "NUM_SPIPE2" } ], "fieldRules": [] }, "sourceSet": [ { "schema": "", "include": "SRC_ALLNUM_8K" } ], "columnTransformations": [] } } } ] }
{ "totalCount": 1, "pageNo": 0, "pageSize": 25, "documents": [ { "taskId": 757421, "name": "oracle_to_snowflake_combined", "documentState": "VALID", "documentType": "DBMI_TASK", "parentInfo": [ { "parentId": "7cCn5thwWFLhiZoSosphKL", "parentName": "REG", "parentType": "Space" }, { "parentId": "3uDIOqah80qbMK3cXAceIp", "parentName": "Default", "parentType": "Project" } ], "description": "", "owner": "6r2IItttmU3ibDwPqxnRwb", "createdBy": "6r2IItttmU3ibDwPqxnRwb", "createdTime": "2026-10-08T08:44:09.000+00:00", "accessedTime": "2026-10-08T09:49:30.311+00:00", "updateTime": "2026-10-08T09:49:30.311+00:00", "dbmiTask": { "type": "dbmi", "general": { "name": "oracle_to_snowflake_combined", "description": null, "location": "Default", "runtimeEnvironment": "invyaminirh01.informatica.com", "type": "combined" }, "source": { "connection": "Oracle_19RDS_yk-CDC", "customProperties": { "loadType": "CDC_COMBINED", "journalName": "", "dbmi.cdc.query.based.column.type": "COLUMN_TYPE_TIMESTAMP", "pwx.cdcreader.postgresql.connection.repl.publication": "", "dbmi.cdc.interval.mins": "5", "dbmi.cdc.interval.hours": "0", "readerInputIsPersisted": "true", "dbmi.cdc.technique": "LOG_BASED_CDC", "unload.source.partition.count": "5", "pwx.cdcreader.postgresql.connection.repl.slotname": "", "lobsEnabled": "true", "dbmi.cdc.interval.days": "0", "selectionMode": "RULE_BASED" }, "restartPointForIncrementalLoadTimestamp": null, "schema": "SP_UNLOAD", "includeViews": null, "replicationSlotName": "", "replicationPlugin": null, "publication": "", "journalName": "", "restartPointForIncrementalLoad": "LATEST", "restartPointForIncrementalLoadPosition": null, "cdcTechnique": "LOG_BASED_CDC", "cdcQueryBasedColumnType": "COLUMN_TYPE_TIMESTAMP", "cdcQueryBasedColumnName": null, "cdcQueryBasedDateColumn": null, "cdcQueryBasedTimeColumn": null, "context": null, "accountId": null, "propertyId": null, "viewId": null, "pathToReportConfigurationFile": null, "product": null, "services": null, "outputType": null, "salesforceAPI": null, "fetchSize": null, "fetchSizeForInitialLoad": null, "fetchSizeForIncrementalLoad": null, "startDate": null, "endDate": null, "cdcIntervalDays": "0", "cdcIntervalHours": "0", "cdcIntervalMins": "5", "extractNonDefaultFields": null, "includeArchivedAndDeletedRows": null, "includeBase64Fields": null, "maximumBase64BodySize": null, "batchSize": null, "mid": null, "readerInputIsPersisted": "true", "readerHistoricalCacheUseCloud": null, "lobsEnabled": "true", "unloadFlashbackDisabled": null, "enableAlternateSource": null, "alternateSourceId": null, "cdcStagingMigration": null, "cdcStagingMigrationTasks": null, "jdbcPartitioningTechnique": null, "sourceMaxParallelPartitions": null, "unloadHelperThreadCount": null, "readEventBatchSize": null, "readerHelperThreadCount": null, "salesforceBulkV2Partitioning": null, "salesforceBulkV2RecordsPerPartition": null, "salesforceBulkV2MaxParallelPartitions": null, "workdayReplicationType": null, "workdayReportsNumber": null, "workdayReportName": null, "workdayReportsConfigFile": null, "oracleFusionInterfaceType": null, "oracleFusionModuleName": null, "oracleFusionEnableChildObjects": null, "formattedStartDate": "", "formattedEndDate": "", "selectionRules": [ { "include": "COMPO8" } ] }, "target": { "connection": "Snowflake_pat_sp", "schema": "SNOW_PB", "outputFormat": "CSV", "fileCompressionType": "None", "parquetFormat": "true", "fixedDirectoryForEachTable": "false", "renamingRules": [ { "source": "COMPO8", "target": "COMPO8_O9" } ], "dataTypeRules": [], "stage": "gkn", "bucket": "", "directory": "", "addBeforeImages": "true", "directoryTags": "", "useTableNameAsTopicName": "false", "includeSchemaName": "false", "asyncWrite": "true", "writerSnowflakeIngestionMethod": "", "writerSnowflakeDeferredMergeInterval": "3600", "addLastReplicatedTime": "true", "cycleId": "true", "customProperties": { "rat.audit.columns.optime": "true", "rat.audit.columns.opseq": "true", "targetDirectory": "", "rat.cdcfile.target.directory": "", "writerSnowflakeIngestionMethod": "", "targetIdentifiersEnableCaseTransformation": "true", "rat.audit.columns.optype": "true", "targetIdentifiersCaseConversionStrategy": "NO_TRANSFORMATION", "rat.target.columns.last.replicated.time": "true", "rat.audit.columns.optxid": "true", "applyMode": "audit", "targetBucket": "", "rat.audit.columns.opowner": "true", "writerSnowflakeDeferredMergeInterval": "3600", "auditColumnsPrefix": "INFA_", "rat.target.columns.cycleId": "true" }, "auditData": { "applyMode": "audit", "auditColumnPrefix": "INFA_", "addOperationType": "true", "addOperationTime": "true", "addOperationOwner": "true", "addOperationTransactionId": "true", "addOperationSequence": "true" }, "caseTransformation": "none" }, "runtimeOptions": { "numberOfRowsInOutputFile": null, "fileExtensionBasedOnFileType": null, "applyCycleChangeLimit": null, "applyCycleIntervalDays": null, "applyCycleIntervalHours": null, "applyCycleIntervalMins": null, "applyCycleIntervalSecs": null, "lowActivityFlushHours": null, "lowActivityFlushMins": null, "checkpointAllRows": null, "checkpointEveryCommit": null, "checkpointRowCount": null, "checkpointFrequencySecs": null, "executeInTaskflow": false, "enableAutoTuning": false, "schemaDriftOptions": { "addColumn": "replicate", "renameColumn": "ignore", "modifyColumn": "replicate", "dropColumn": "ignore" }, "customProperties": { "writerRecoveryEnableCycleUpdates": "false", "enableAutoTuning": "false" } }, "replicationRules": { "source": "SP_UNLOAD", "target": "SNOW_PB", "overrides": { "tableRules": [ { "source": "COMPO8", "target": "COMPO8_O9" } ], "fieldRules": [] }, "sourceSet": [ { "schema": "", "include": "COMPO8" } ], "columnTransformations": [] } } } ] }
