Support for SQL for Complex Target Mappings in Quick Mode

Data Integration now supports SQL for complex target mappings in Quick Mode. You can use #SQL mappings and SQL target expressions to derive target dimension values by applying CASE logic, SQL character functions, and conditions based on multiple source columns. To reference a source dimension included in the import format, enclose its name in dollar signs, such as $ACCOUNT$, $ENTITY$, or $UD1$.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Tax Reporting

Business Benefit: This enhancement removes a key barrier to using Quick Mode for integrations with complex transformation requirements. Customers can preserve SQL-based mapping logic, derive target values from multiple source columns, and reduce the need for custom preprocessing or extensive mapping redesign when moving integrations from Standard mode to Quick Mode.

Key resources

• SQL Mapping in Quick Mode in Administering Data Integration