Informatica Data Warehousing Question:

What are variable ports and list two situations when they can be used?

Informatica Data Warehousing Interview Question
Informatica Data Warehousing Interview Question

Answer:

We have mainly tree ports Inport, Outport, Variable port. Inport represents data is flowing into transformation. Outport is used when data is mapped to next transformation. Variable port is used when we mathematical calculations are required. If any addition i will be more than happy if you can share.

We can use variable ports to store values of previous records which is not otherwise possible in Informatica.


Previous QuestionNext Question
Is union Transormation is Active transformation?Whats the diff between Informatica powercenter server, repositoryserver and repository?