map two table columns using pentaho Data integration

0
votes

I am using pentaho data integration in which I am able to get table columns but while editing I want the columns to save as edited but it giving some error able to save in .txt file and want to get as input for next transformation.

How to map two table columns using pentaho Data integration?

1
mappingpentahoeditingdata-integration
what error? provide more info. – fenix
how can we edit columns using pentaho?? – Payal Agrawal

1 Answers

0
votes

Join the two tables using basic sql in the table input step itself or using merge join with their foreign key relations. keep this result is txn1. Now, create a job with two transformations. Use the output to above txn1 to another transformation.