Book Image

Pentaho Data Integration Cookbook - Second Edition - Second Edition

Book Image

Pentaho Data Integration Cookbook - Second Edition - Second Edition

Overview of this book

Pentaho Data Integration is the premier open source ETL tool, providing easy, fast, and effective ways to move and transform data. While PDI is relatively easy to pick up, it can take time to learn the best practices so you can design your transformations to process data faster and more efficiently. If you are looking for clear and practical recipes that will advance your skills in Kettle, then this is the book for you. Pentaho Data Integration Cookbook Second Edition guides you through the features of explains the Kettle features in detail and provides easy to follow recipes on file management and databases that can throw a curve ball to even the most experienced developers. Pentaho Data Integration Cookbook Second Edition provides updates to the material covered in the first edition as well as new recipes that show you how to use some of the key features of PDI that have been released since the publication of the first edition. You will learn how to work with various data sources – from relational and NoSQL databases, flat files, XML files, and more. The book will also cover best practices that you can take advantage of immediately within your own solutions, like building reusable code, data quality, and plugins that can add even more functionality. Pentaho Data Integration Cookbook Second Edition will provide you with the recipes that cover the common pitfalls that even seasoned developers can find themselves facing. You will also learn how to use various data sources in Kettle as well as advanced features.
Table of Contents (21 chapters)
Pentaho Data Integration Cookbook Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
References
Index

Deleting one or more files


Kettle provides two job entries for deleting files: Delete file and Delete files. You can find both in the File management category of entries.

In this recipe, you will see an example of how to delete a file. You will delete a file that includes the current date as part of its name, for example test_20101020.txt.

Getting ready

You must create a sample file; for example, test_20101020.txt. Make sure to use your current date instead of 20101020. Use the same format (yyyyMMdd).

How to do it...

Perform the following steps to learn how to delete one or more files:

  1. Create a new transformation.

  2. Drop a Get System Info step from the Input category into the work area.

  3. Double-click on the step and add a field named date. In the Type column, select system date(fixed).

  4. Add a Select values step from the Transform category. Open it, and under the Meta-data tab, add date as Fieldname, set the type to String, and type or select yyyyMMdd in the Format column.

  5. From the Job category, add a...