Skip to Content
0
Former Member
Feb 23, 2009 at 05:11 PM

TABLE JOIN USE?

31 Views

Hi,

What is the real use of Table join?

Does it eliminate the redundant data by joining the fields. I was experimenting CASE_STUDY from MDM100 on Products and Divisions table.

I joined the Products and Divisions by field Division

I imported all the data in to Divisions and expecting thay will not ask for value mapping during Products table data import.

But interestinly it was asking me for value mapping. Then what is use of having a join.

Scenario based explaination will clear by doubt. If possible please give me .a2a file to work out with this. of course simulation will be great help.

Thanks