Issue in transformation job. Unable to find [JOIN_KEY] field in a reference stream.

SQLPower / power-architect

Automatically exported from code.google.com/p/power-architect

GNU General Public License v3.0

174 stars 65 forks source link

Issue in transformation job. Unable to find [JOIN_KEY] field in a reference stream. #28

Closed KirtiMistry closed 3 years ago

KirtiMistry commented 3 years ago

This issue occurred due to not specifying the [JOIN_KEY] in a Select statement. Transformation generated from Architect doesn't include a join key in a Select statement.

vinodgopu commented 3 years ago

Present : in select statement joining key (i.e. std_id) is not included / specified even though in merge step joining key has populated, In pentaho Joining key has to exists in both tables.

vinodgopu commented 3 years ago

Expected :

vinodgopu commented 3 years ago

If we don't have joining key from the input reference stream before joining step Pentaho through error at runtime for example :

vinodgopu commented 3 years ago

Tested in new build, working as expected