What are various types of Aggregation?

Various types of aggregation are SUM, AVG, COUNT, MAX, MIN, FIRST, LAST, MEDIAN, PERCENTILE, STDDEV, and VARIANCE.

 

What is Code Page Compatibility?

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.

Superset – A code page is a superset of another code page when it contains the character encoded in the other code page, it also contains additional characters not contained in the other code page.

Subset – A code page is a subset of another code page when all characters in the code page are encoded in the other code page.

 

 

 

 

Advertisements