Loading demo links...
What to study for each Cloud-Data-Integration-Developer domain
Informatica Cloud Overview
Informatica Cloud overview: IDMC as the platform of services and the Secure Agent's role in executing work where the data resides.
Key skills
IDMC services, Secure Agent
Introduction to Data Integration Service
Introduction to the Data Integration service: connections, mappings, mapplets and the tasks that run integration logic.
Key skills
CDI assets, mapping vs mapping task
Synchronization Task
The synchronisation task: wizard-driven loads between two systems, target operations, field mappings, filters and incremental patterns.
Key skills
Sync task wizard, operations, field mapping drift
Data Transfer Task
The Data Transfer task: guided data movement with optional transfer transformations, and when to prefer a full mapping instead.
Key skills
Data Transfer scenarios, de-duplication options
Basics of Cloud Mapping Designer
Basics of the Cloud Mapping Designer: transformations, field rules and propagation, expression fields, validation and parameterised objects.
Key skills
Field rules, validation, expression fields
IICS Transformations
IICS transformations: Filter, Expression, Aggregator and Sorter and their row behaviour in a mapping.
Key skills
Core transformation behaviour
Joiner and Lookup Transformations
Joiner and Lookup transformations: pipeline joins versus per-row enrichment and unmatched-row behaviour.
Key skills
Joiner types, lookup NULL handling
Mapplets
Mapplets in CDI: reusable transformation logic with defined input and output interfaces shared across mappings.
Key skills
Mapplet interfaces, reuse
Mapping Parameterization
Mapping parameterization: in-out parameters, task-supplied values and parameterising filters for reuse.
Key skills
In-out parameters, parameter overrides
Mapping Task
The mapping task: runtime environment, parameter values and execution options that bind a mapping for a run.
Key skills
Task configuration, pre-run errors
Replication Task
The replication task: replicating source objects to targets with table creation and full and incremental loads.
Key skills
Replication scope, incremental loads
Masking Task
The masking task: masking techniques such as substitution, shuffle and blurring applied when copying sensitive data.
Key skills
Masking techniques
Taskflows
Taskflows: orchestrating tasks in sequence or parallel with decisions, waits and step error handling.
Key skills
Taskflow steps, decisions
IICS REST APIs
IICS REST APIs: logging in for a session and programmatically running jobs, checking status and managing assets.
Key skills
REST login, job resources
IDMC Architecture
IDMC architecture: the Administrator service, organisations, Secure Agent groups and runtime environments.
Key skills
Administrator service, runtime environments
Dynamic Mapping Task
Dynamic mapping tasks: running one parameterised mapping for many source-target combinations through generated jobs.
Key skills
Dynamic jobs, parameterised design requirements
User Defined Functions
User defined functions: reusable expression logic callable from any mapping expression.
Key skills
UDF reuse and maintenance
Transaction Control Transformation
The Transaction Control transformation: expression-driven commit and rollback boundaries for transactional targets.
Key skills
Commit control, transactional target requirements
Dynamic Schema Handling
Dynamic schema handling: field rules and schema drift options that let mappings tolerate evolving source structures.
Key skills
Schema drift options
Advanced Taskflow Techniques with File Listener
Advanced taskflow techniques with file listeners: event-driven orchestration triggered by arriving, stabilised files.
Key skills
File listeners, file stabilisation
Dynamic Lookup Cache
Dynamic lookup caches: caches updated during the run, used for patterns such as surrogate key generation.
Key skills
Dynamic cache behaviour
Advanced Parameterization
Advanced parameterization: parameter files and hierarchical overrides from taskflows through tasks to mappings.
Key skills
Parameter files, override hierarchy
Data Ingestion and Replication Task
Data Ingestion and Replication tasks: initial loads, incremental loads and change data capture for high-volume replication.
Key skills
CDC, initial and incremental loads, lag monitoring
Exception Handling
Exception handling: routing bad rows to exception outputs in mappings and fault handling on taskflow steps.
Key skills
Error routing, step fault handling
Normalizer Transformation
The Normalizer transformation: expanding repeating fields in a row into multiple rows for occurs-style sources.
Key skills
Normalising repeating groups
Hierarchical Connectivity
Hierarchical connectivity: Hierarchy Parser and Hierarchy Builder transformations and the schemas or models they need.
Key skills
Parsing and building hierarchy
Intelligent Structure Model
Intelligent structure models: discovering the structure of complex files from samples and using the model to parse them in mappings.
Key skills
Intelligent Structure Discovery, model use and maintenance
SQL ELT Optimization
SQL ELT optimization: pushing mapping logic into the database engine, and the conditions for full versus partial pushdown.
Key skills
Pushdown types and requirements
Mapping Partitioning
Mapping partitioning: parallel partitions by round robin, key range or hash to increase task throughput.
Key skills
Partitioning types
Advanced Integration
Advanced integration: invoking CDI work from CAI processes and driving tasks and taskflows through the REST API.
Key skills
CAI-CDI invocation, API-driven execution