Category Archives: Informatica

LAB 5: USING JOINER TRANSFORMATION

BUSINESS REQUIREMENT: Suppose that we are trying to keep the Customers address information. For that we need the mentioned address as well as the geographical location of that place. A geographic dimension is already created which has to be populated first. The geographical information is a normalized structure whereas the dimension is a denormalized table.

Read More