As a part of upgrade validation, run the below list of sample jobs after the Infoworks upgrade.
- Ingestion for Full-load, CDC and Merge[ For existing sources]
- Perform a JDBC ingestion for Teradata/Oracle
- Perform a TPT based ingestion for Teradata
- Perform log based ingestion for Oracle.
- Perform a CDC/Merge for Any given sources ( Ingestion Now option).
- Perform a CSV/Fixed-width or JSON ingestion.
- Take a Sample/Dummy table to ingest it and then perform a restructure job by modifying the tables split by column, reducer count, and Secondary. partition values.
- Perform a Reconciliation job for validation.
REST API Calls
- Perform a test to check Auth token is working.
- Perform All possible REST API calls using the below links ( Please note: This is quite a large list of REST calls, choose few from the list) http://docs.infoworks.io/versions/2.5.0/infoworks_rest_api/
- Create a Domain.
- Create a Pipeline.
- Build a Pipeline using Hive as Engine.
- Build a pipeline using Spark as Engine.
- Export a pipeline target to Teradata or any available Sources.
- Check Interactive data and build a pipeline.