Unit 4: Use Case #1 – One-to-One Mapping

In this unit, we'll take a closer look at the first use case involving one-to-one mapping.

One-to-one mapping – resolving a challenge

As we dive deeper into examining our first use case of transcoding data using one-to-one mapping, we are presented with the following challenge as an example:

  • Source dataset has the dimensions with ID "FREQ", "REF_AREA", and "INDICATOR"
  • The REF_AREA dimension consists of 2-Letter ISO2 country codes
  • Target dataset needs to have 3-letter ISO3 country codes

Select each option to learn about the solution to this challenge, along with specific values.

Solution
Solution

One solution is to create a single component map, which maps the source REF_AREA based on the ISO2 coding scheme to the output REF_AREA based on the ISO3 coding scheme. Component map: Source= REF_AREA; Target=REF_AREA_ISO3.

The above component map is backed by a single representation map, which maps each ISO2 code to the matching ISO3 code. REF_AREA -> REF_AREA_ISO3

Values
Values
  • AF=AFG
  • AL=ALB
  • AU=AUS

One-to-one mapping in action

Let's now consider an example of one-to-one mapping in action. In this short video, we'll examine creating the structures in FMR and then transcoding the datafiles using the UI and the API – sync & async.

Select Play to begin.

To access the code presented in this video, click here.

Coming next

Next, we'll take time to go over the second use case involving one-to-many mapping.

AI assistant

Need help finding something? I am an AI Assistant that's here to help!

Welcome to SDMX AI assistant

What are you looking for?

SDMX AI assistant

By using this AI-powered service ("Service"), you acknowledge and agree to the following:

This Service uses generative AI to assist with statistical analysis and research. While the Service strives to deliver useful information, the output ("Output") may contain inaccuracies, omissions, or biases. The Output is provided for informational purposes only and should not be considered professional advice. You remain responsible for how you interpret and use the Output.

The BIS makes no warranties regarding the accuracy or completeness of the Output and accepts no liability for any loss or damage resulting from its use.

Do not include or share personal, private, confidential or proprietary information when using the Service.

By using this technology, you agree to the Terms and Conditions.

How the assistant can help you

Understand SDMX standards

Ask and get clear explanations about SDMX standards.

Navigate the website

Find tools and documentation on website quickly.

Explore SDMX tools

Ask about API, software and libraries supporting SDMX.

Access documentation

Locate technical guides, specifications, and FAQs.