Let's take a look at an example that demonstrates how you can add and correct mapping details during a conversation.
1You submit the following prompt to start the conversation:
Create an integration pipeline to move records from Oracle to a flat file.
CLAIRE Copilot replies with the following statement:
It looks like you're trying to create a mapping.
Let's gather some more information.
Here's a list of connections for the source:
1. Oracle connection
2. Oracle_QA
3. Oracle_connection
4. Oracle connection 2
5. Oracle_lp_3
2You submit the following prompt:
Let's use 3.
CLAIRE Copilot replies with the following statement:
The Source's connection of Oracle_connection validation is successful, but object name is not provided, please verify.
3You submit the following prompt:
Check if the EMPLOYEE table is present and use it if it's there.
CLAIRE Copilot replies with the following statement:
The Source connection of Oracle_connection, object name of EMPLOYEE validation is successful.
Here's a list of connections for the target:
1. FF_lp_conn
2. FF_lp_tgt
3. flatfile_source
4. flatfile_source2
5. flatfile_target
4You submit the following prompt:
Wait, I wanted to use EMPLOYEE using flatfile_source connection. Can you change the source connection?
CLAIRE Copilot replies with the following statement:
The Source connection of flatfile_source, object name of EMPLOYEE validation is successful.
Here's a list of connections for the target:
1. FF_lp_conn
2. FF_lp_tgt
3. flatfile_source
4. flatfile_source2
5. flatfile_target
5You submit the following prompt:
I want to insert the data into a file called "Employee_Oracle_Records" using the flatfile_target connection.
CLAIRE Copilot replies with the following statement:
The Target connection of flatfile_target, object name of Employee_Oracle_Records validation is successful.
All connections have been identified and updated.
Then, CLAIRE Copilot generates a summary of the mapping and asks you if you want to create it.
6You submit the following prompt:
Can you filter the records where location is 'US'?
CLAIRE Copilot updates the mapping summary and asks you again if you want to create the mapping.