You can perform the following tasks to manage user-defined functions:
The following table describes the user-defined function management tasks and lists where you can perform each task:
Editing User-Defined Functions
You can edit a user-defined function to change the function properties. The changes propagate to all user-defined functions and expressions that use the function.
Use the following rules and guidelines when you edit a user-defined function:
Deleting User-Defined Functions
When you delete a user-defined function, the Repository Service deletes the function from other user-defined functions and expressions that use it. As a result, these user-defined functions and expressions may be invalid.
Mappings and workflows that use the user-defined function or an expression with the user-defined function may also be invalid. Validate the mappings or workflows.
Exporting User-Defined Functions
You can export a user-defined function to XML. You can then import it into other repositories or repository folders.
If you export a mapping or workflow with a user-defined function, the PowerCenter Client exports the user-defined function.
Validating User-Defined Functions
You can validate a user-defined function from the following areas:
When you validate a user-defined function, the PowerCenter Client does not validate other user-defined functions and expressions that use the function. If a user-defined function is invalid, any user-defined function and expression that uses the function is also invalid. Similarly, mappings and workflows that use the user-defined function are invalid.
Copying and Deploying User-Defined Functions
When you copy an object that contains a user-defined function, the Copy Wizard also copies the user-defined function. When you deploy a static deployment group that contains user-defined functions, the Copy Wizard also copies the functions. When you deploy a dynamic deployment group that contains user-defined functions, the Copy Wizard does not deploy the functions that are not included in an expression.
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.