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.

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, adding, and correcting 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.

You can also 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.