I am on a mission. Several actually, but this one is about enabling the masses of PDI and Kettle users to keep their proverbial ducks in a row.
What I’m talking about is the bevy of errant connections that are meant to be straight, but are off ever so slightly. But you and I know better, we see that errant line, the angle that is off by 3 degrees. And it MUST BE FIXED!
Let’s look at an example. Below we have a transformation that reads some sales data, does some data cleansing and data enrichment, and outputs the results into a fact table. Now does that look terrible or what? Every line is crooked.
If you’re like me, you’ll spend extra time making sure every line is truly straight. Then, you’ll need to add or change something about your transformation and do the line-straightening thing all over again. Let’s face it, that’s a waste of time. Wouldn’t it be great if there was a way to have our ETL steps automatically lock into place, say, on a grid perhaps? Well you’ve come to the right place. Open up the Tools –> Options menu.
Switch to the “Look & Feel” tab, and change the “Grid Size” field to something larger. I’ve found 30 to be a good value to set here, mostly because that’s what Lynn Yarbrough suggested during my PDI training class. Thanks Lynn!
Now we can clean up our transformation and straighten everything out with the quickness! Check it out:
See? Look how nice that is.
So there you have it – the best PDI / Kettle tip ever for orderly people. Don’t you agree? Learn more goodies like this in our PDI training course!