Pentaho database join step

Data Warehousing

Pentaho: (Year: 2014 )

Working Database join step
















This will not work











you cannot replace table name and field name using parameters
of database join step
Instead you have to create 2 transformations. 1 for setting variables and 2 for using them.

Comments

Post a Comment

Popular posts from this blog

Pentaho ETL

Image
Pentaho  Here, I am trying to write down my finding in Pentaho (Spoon). So that, I can quickly look back if I need to. This is more like a personal note and as of now, I am not sure if this could be of any help to others. 07 Feb 2014 ERROR HANDLING How to enable it? You can right click on the steps and you can see an option called Error Handling. Note: Not all the steps have this option. Error handling is disabled for Table input step, stream look-up step etc.. How to define the field names? You can give the names you are interested in for the predefined fields of error handling. So, these fields will be added to the fields flowing in your current stream Currently, for the Pentaho 5.0, we are having a bug for ERROR_COUNT field, which is getting type as Long instead of Integer for some of the rows. So, as a temporary fix, we have used javascript to handle this public boolean processRow(StepMetaInterface smi, StepDataIn...
Read more

Copy files from one computer to other using ‘scp’ command

Image
copy files between computers using scp cmd scp file.txt remote_username@10.10.0.2:/remote/directory From the computer which has the source file, go to the command line and, provide the path of the source file followed by scp and then, username@hostname of the remote computer and then, the path where you want it to be copied on remote computer. Another example: Default port number is 22. So we generally use -P in case we have to explicitly specify any port other than 22 like below scp -P 2000 Downloads/simple2.html pi@raspberrypi.local:~/learning/python/webscraping Copy local directory to remote computer scp -r localDirectory user@remotecomp:/path-to-destination Working example: scp -r capturing-images pi@raspberrypi.local:/home/pi/Downloads Copy from Pi to your Mac scp user@remote:path-to-file . Dot at the end means to copy to the current directory of the mac Working examples: (Run from Mac terminal) a) Copy img1.jpeg file from remote to...
Read more