Use CLAIRE Copilot to help you create and summarize mappings in Data Integration, and to answer questions about the Informatica help.
You can use CLAIRE Copilot for the following tasks:
Create mappings
You can ask CLAIRE Copilot to create a mapping by describing a use case and data flow in the conversation window.
Summarize mappings
You can ask CLAIRE Copilot to provide a brief summary or a detailed summary of an existing mapping. A brief summary returns a high-level overview of the mapping, and a detailed summary returns information about how the individual transformations in the mapping are configured.
Ask questions about Data Integration
CLAIRE Copilot can answer questions to help you use Data Integration. For example, you can ask CLAIRE Copilot about mappings, transformations, and functions so that you can use the information to write a mapping prompt.
CLAIRE Copilot can create mappings that include the following transformations:
•Source
•Target
•Aggregator
•Expression
•Filter
•Joiner
•Lookup
•Rank
•Router
•Sorter
•Union
For best results, provide all details in the first prompt that you submit. For example, the following prompt specifies the source and target objects, source and target connections, and transformations to configure 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 provide all the details that CLAIRE Copilot needs to create a mapping in the first prompt, CLAIRE Copilot asks you to provide them, 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.
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.
CLAIRE Copilot doesn't create or summarize mappings in advanced mode or in SQL ELT mode.