In Informatica Mapping Designer, transformations have three types of ports: Input ports (data enters), Variable ports (for intermediate calculations/storage), and Output ports (data exits). This allows for complex data transformation logic within a transformation.