Which approach meets your need to join Fusion Applications data extracted through FDI with external data?

Which approach meets your need to join Fusion Applications data extracted through FDI with external data?

• A. Use Data Augmentation
• B. Use ADW external data
• C. Use FDI Semantic model extensions to join the tables
• D. Use external tables

Answer: (C)

Joining Fusion Applications data extracted through FDI with external data is best achieved by extending the FDI semantic model to include the external data and define the join relationships within that semantic layer. The semantic model provides a business-friendly, metadata-driven view of the FDI-extracted data, and by extending it you can map external datasets into the same logical space. This lets you perform joins across Fusion data and external sources without duplicating data or restructuring source systems, while keeping the data lineage clear and the join logic centralized and reusable. External tables or ad hoc data augmentation can work in some scenarios, but they typically require separate ETL steps, additional maintenance, and less flexible analytics. The semantic model extension approach offers a scalable, maintainable way to achieve integrated queries across FDI data and external data.

Joining Fusion Applications data extracted through FDI with external data is best achieved by extending the FDI semantic model to include the external data and define the join relationships within that semantic layer. The semantic model provides a business-friendly, metadata-driven view of the FDI-extracted data, and by extending it you can map external datasets into the same logical space. This lets you perform joins across Fusion data and external sources without duplicating data or restructuring source systems, while keeping the data lineage clear and the join logic centralized and reusable. External tables or ad hoc data augmentation can work in some scenarios, but they typically require separate ETL steps, additional maintenance, and less flexible analytics. The semantic model extension approach offers a scalable, maintainable way to achieve integrated queries across FDI data and external data.