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.
The following sample prompts show the types of use cases and data flows that CLAIRE Copilot can configure in a mapping:
Copy all data from ProductIO table in Salesforce custom table to a file.
Find the total salary of each department from the Aggregator_source file and write it to a different file.
I want to identify all the team members for each account in AccountHistory table and write it to a file. The team member details are present in the Account Team member custom object in Salesforce.
I want to get the vehicles details from the Vehicle__c object in Salesforce for the vehicles which were delivered in the last week from yesterday and move it to a service plan prepare file.
Identify the rows log entries where the statuscode is 200 or 201. Separate them to a folder 1 and the keep the remaining rows in folder 2.
Create 2 copies of the latest manifest file data for esl transaction files to audit/target/esl_transactions/ and source/billing/esl_transactions/. Add a new column with the system timestamp and arrange the data based on the transaction ids from the earliest to the latest.
CLAIRE Copilot can create mappings that include the following transformations:
•Source
•Target
•Aggregator
•Expression
•Filter
•Joiner
•Lookup
•Rank
•Router
•Sorter
•Union
CLAIRE Copilot doesn't create or summarize mappings in advanced mode or in SQL ELT mode.