Informatica Cloud Data Integration - Automation Project

Explore input for the automation project by exporting prebuilt mappings and mapping configuration tasks from IICS. Learn how to export MCTs with dependencies for review of exported mappings.

Unzip the exported Informatica Cloud bundle to view the Excel contents, MCTs, MTT mapping tasks, DTEMPLATE mappings, IDs, and the SYS and Explore folder structure.

Learn how mapping configuration task metadata is stored in json files, including schedule, runtime environment ids, mappings, and session properties, and how to craft a reusable json template.

Create and reuse a hierarchical schema in Informatica cloud data integration by uploading a json sample to a template, validating it, and linking to hierarchy parser for mapping configuration tasks.

Organize and rename the mapping configuration task files, set up a source directory, and build a hierarchical schema with a template to support mapping development.

Develop mappings in Informatica Cloud Data Integration using a hierarchy parser to transform JSON input into relational fields, then output a semicolon-delimited text file.

Develop and test a mapping that resolves mapping and runtime environment ids to names using an unconnected lookup against ContentsoffExportPackage, with expression transformations and cleanup of @ symbols.

Learn to extract mapping configuration task schedule names by creating a schedule.csv from schedule.json. Use an unconnected lookup to populate the output with the schedule name.

Build the mapping by linking root and parameters field segments in Informatica cloud data integration. Use hierarchy parser, expression, and joiner transformations, then sorter and aggregator to remove duplicates.

Extract and read mapping metadata from json files inside a zip exported from ises, inspect the transformation array, source and target details, and build a template mapping_json_template for multiple mappings.

Prepare mapping json files and a hierarchical schema template in informatica cloud. Upload and validate the template, move jsons to the input directory, and set up mapping details for development.

Create a mapping that reads mapping JSON files using a hierarchy parser, joins root and transformation details with a joiner, and outputs a detailed report of mapping names.

Read and map mapping metadata by extracting body fields from annotations and annotations1, join with root and transformations using master outer joins, and output Mapping_details.csv.

Explore mapping detailing: resolve connection names from connectionId via lookup, and inspect outputs with source/target properties across Salesforce and csv-based sources.

Automate Informatica mapping preparation by using AutoReview_Preprocess.sh to read and unzip latest input zip files (MTT.zip and DTEMPLATE.zip), renaming JSONs and creating input lists and schedule data.

Create a linear task flow TF_AutoReview that runs a pre-processing script to prepare JSON and input files from the source zip and then executes MCT details and mapping details mappings.