Why should we know Active and Passive Transformations in informatica?

Why should we know Active and Passive Transformations in informatica?

Suppose the data split-ed and concatenated.

1. if all the branches are Passive transformations, for sure job execute normally.
2. if one of the branch contains at least one Active Transformation the job will fail. In this case we should use joiner with business logic to run the job.

What is Code Page Compatibility?

What is Code Page Compatibility?

When two code pages are compatible, the characters encoded in the two code pages are virtually identical.

Compatibility between code pages is used for accurate data movement when the Informatica Sever runs in the Unicode data movement mode. If the code pages are identical, then there will not be any data loss. One code page can be a subset or superset of another. For accurate data movement, the target code page must be a superset of the source code page.

What is code page in informatica

The code page in informatica is used to specify the character encoding. It is selected based on the source data. If the source data contains japanese characters, then the code page is selected to support japanese text. When a code page is chosen, the program or application for which the code page is set, refers to a specific set of data that describes the characters the application recognizes. This influences the way that application stores, receives, and sends character data.

Most commonly selected encoding systems are:
ASCII
UTF-8
UTF-32