Lookup Transformation would be helpfull while we try to load data in to foreign key table.
Order table is primary key table , Product is the foreign key table that relates to the order table.
Firstly Load all the data in the primary key table , while we try to load the foreign key table,Need to mach the column from either side to get the primary key in order to populate corresponding foreign key column.
To get the primary key as shown as below
Input column sorce feed for the foreign key table , right side is the look up table which is called primary key product table as shown as below.
Order table is primary key table , Product is the foreign key table that relates to the order table.
Firstly Load all the data in the primary key table , while we try to load the foreign key table,Need to mach the column from either side to get the primary key in order to populate corresponding foreign key column.
To get the primary key as shown as below
Input column sorce feed for the foreign key table , right side is the look up table which is called primary key product table as shown as below.
No comments:
Post a Comment