To create a mapping using CLAIRE Copilot, you can submit a complete mapping prompt to CLAIRE Copilot or you can start with a basic prompt and then fill in missing details, add details, and correct details through the conversation interface.
You can create and design mappings in the following ways:
Submit a complete mapping prompt
For best results and performance, provide all details about the mapping in the first prompt that you submit to CLAIRE Copilot.
A complete mapping prompt includes the following details:
- Source and target connection names
- Source and target object names
- Optionally, transformation details
For example, the following prompt specifies the source and target connections, source and target objects, and transformations in the mapping:
Read 'DEPT_MAIN' from Oracle connection 'Oracle_connection', group the incoming data based on field 'DEPTNAME', and create a new field named 'MIN_SALARY' that has the minimum value of the 'SALARY' field and a field named 'AVE_SALARY' which has the average salary. Write the resulting data to a table named 'DEPT_P' in the same Oracle connection.
Start with a basic prompt
If you don't have a complete mapping prompt, you can start the conversation with a basic prompt like I want to create a mapping and design the mapping in subsequent prompts by filling in missing details, adding details, and correcting details.
Fill in missing details
When you start the conversation with a basic prompt, CLAIRE Copilot asks you to provide the details it needs to create the mapping, such as source and target connections or source and target objects. If CLAIRE Copilot gives you a list of options for connections or objects to choose from, you can enter the name or number of the list item. Otherwise, you can type the name of the connection or object in the prompt text box.
Add and correct details
During the conversation, you can submit prompts to add details to the mapping or correct prior details. For example, you can submit a prompt to specify an additional filter condition for a Filter or Router transformation. Or, you can change the connection or object for the source or target.
Note: If you previously specified a filter condition, you can no longer change it during the same conversation. To specify a different filter condition, start a new conversation or type Start Over.
When CLAIRE Copilot has enough information to create the mapping, it generates a brief summary that you can review. You can continue making changes to the mapping in the conversation window, or you can ask CLAIRE Copilot to create it and open it.
Note: After CLAIRE Copilot opens the mapping, you can no longer edit the asset in the conversation window, but you can continue to make edits manually.