Use the PowerCenter Express client applications to complete your data integration solutions. Use the Developer tool to create connections, import metadata, run profiles, create mappings, and run mappings as part of workflows. Then, use the Administrator tool to monitor workflow progress.
Step 1. Create connections
Create connections to access data from relational databases, third-party web services, or social media web sites. Create a connection to create data objects, preview data, run profiles, and run mappings. The Developer tool uses the connection when you import a data object. The Data Integration Service uses the connection when you preview data, run profiles, and run mappings.
For Informatica Power Center Live Instructor Led Online or Corporate Training Contact Info@VirtualNuggets(Dot)Com
Step 2. Import metadata to create data objects
Import metadata to create data objects for sources and targets that you want to use in a mapping. When you develop a mapping, you can use data objects to define the input and output of the mapping.
Step 3. Run a profile
Run a profile to analyze the structure and content of your data, and to determine the quality of your data. When you run a profile, the Data Integration Service applies the profiling rules and runs the profile.
Step 4. Develop mappings
Develop mappings to implement data integration tasks. A mapping is a set of inputs and outputs that represent the data flow between sources and targets. Link the sources and targets with transformation objects that define the rules for data transformation. The Data Integration Service uses the instructions configured in the mapping to read, transform, and write data. You can add a mapping as a task in a workflow.
Step 5. Create and run workflows
Create a workflow to define a sequence of events, tasks, and decisions based on a business process. Then, deploy the workflow to the Data Integration Service and run the workflow. The Data Integration Service uses the instructions configured in the workflow to run the objects.
Step 6. Monitor workflows
Monitor the workflow instance run on the Monitoring tab of the Administrator tool. The Monitoring tab shows the status of running workflow and workflow object instances. You can abort or cancel a running workflow instance in the Monitoring tool. You can also use the Monitoring tool to view logs for workflow instances and to view workflow reports.