Sorter Transformation Use the Sorter transformation to sort data in ascending or descending order according to specified sort criteria. You can configure a Sorter transformation to achieve case-sensitive sorting and unique output. Sorter transformati...
All About Lookup TransformationLookup transformations allow you to search for data in flat files, relational tables, views, or synonyms. You can import search definitions from flat files or relational databases that both PowerCenter clients and integ...
What are different types of tasks available in informatica Power Centre?Assignment Task: Value is assigned to a workflow variable by Assignment task type.Command Task: It executes a shell command during the time of workflow execution.Control Task: Co...
What are the output files that are created by the Informatica server at runtime?At run time, the Informatica server creates the following output files:Informatica Server Log: This type of file is typically stored in the Informatica home directory and...