Incremental data loading can be achieved in pentaho using Inser/Update controls. The following steps helps one to understand the control:
1. Create a new transformation, containing source and target data connections.
2. Add a "Table Input" configure the connection properties and input columns. In below example two columns EmployeeID and EmployeeName are selected from Employee table.
3. Add a Insert/Update control join by hop.
4. Configure the insert update control as shown below (Steps 1, 2, & 3).
5. My target table is DimEmployee, and look up column in EmployeeID (Steps 4 &5).
6. Click on Get Update fields (Step 5). Map Input and Output columns.
7. Set update Y or N for columns (Y for allow updates, N for fixed attribute).
8. Click OK.
1. Create a new transformation, containing source and target data connections.
2. Add a "Table Input" configure the connection properties and input columns. In below example two columns EmployeeID and EmployeeName are selected from Employee table.
3. Add a Insert/Update control join by hop.
4. Configure the insert update control as shown below (Steps 1, 2, & 3).
5. My target table is DimEmployee, and look up column in EmployeeID (Steps 4 &5).
6. Click on Get Update fields (Step 5). Map Input and Output columns.
7. Set update Y or N for columns (Y for allow updates, N for fixed attribute).
8. Click OK.
Hi Mahadev
ReplyDeleteI am developing reports using pentaho report designer(prd),i am using 5 subreports in one report.
My intention is to use same datasource (JNDI) connection from main report to all the sub reports instead of using
connections for each and every report.
is it possible,if possible can u pls let me know the process.
Also please explain me how to set the pool property in reports.
Thanks in advance,
Karthikeya
Keep posting..Thanks for sharing your knowledge.I am new to pentaho.
ReplyDeleteI have question regarding "How to migrate code of pdi from one server to another? with all parametes or if any file is passed as input?" request you to please explain in detail so as to improve my knowledge.
HI Mahadev I only want INSERTs..I do not want update. then do I need to select fields in 'Update fields:' section and set 'Update' to N ?
ReplyDelete