kettle官方demo.rar

【实例简介】
kettle的官方demo，非常适合初学者学习
【实例截图】
【核心代码】
4744302543362263078.rar
└── samples
├── jobs
│   ├── arguments
│   │   ├── Run transformation.ktr
│   │   └── Set arguments on a transformation.kjb
│   ├── arguments2
│   │   ├── parameters.txt
│   │   ├── pass_arguments.kjb
│   │   └── writeback.ktr
│   ├── changelog
│   │   └── Process changelog.kjb
│   ├── changelog-groups
│   │   ├── Create groups in the changelog data.ktr
│   │   ├── Process changelog with temp table.kjb
│   │   └── process per group.ktr
│   ├── evaluate-result-rows
│   │   ├── Create result rows.ktr
│   │   └── Evaluate result rows.kjb
│   ├── output
│   ├── parallel synchronized jobs
│   │   ├── SyncJobs Example1.kjb
│   │   ├── SyncJobs Example2.kjb
│   │   └── SyncJobs.kjb
│   ├── process all tables
│   │   ├── Get list of tables.ktr
│   │   ├── Process all tables.kjb
│   │   ├── Process one table.kjb
│   │   ├── Process one table.ktr
│   │   ├── save list of all result files.ktr
│   │   └── set variables.ktr
│   ├── process flow with adding streams
│   │   ├── files-output
│   │   │   └── alltogether_131018_174104.txt
│   │   ├── process flow step 1 - start.kjb
│   │   ├── process flow step 2a - input1.ktr
│   │   ├── process flow step 2b - input2.ktr
│   │   └── process flow step 3 - output.ktr
│   ├── run_all
│   │   ├── Define FILENAME Variable and execute.kjb
│   │   ├── Run all sample transformations.kjb
│   │   └── Set Variable.ktr
│   ├── shell for every row
│   │   ├── shell for every row.kjb
│   │   ├── shell for every row - testdata.ktr
│   │   └── shelltest.cmd
│   └── Slowly Changing Dimension
│   ├── create - populate - update slowly changing dimension.kjb
│   ├── DimensionLookup - update dimension table 2.ktr
│   └── DimensionLookup - update dimension table.ktr
├── mapping
│   ├── Mapping - simple mapping.ktr
│   └── Mapping - use simple mapping.ktr
└── transformations
├── Add a checksum - Basic CRC32 example.ktr
├── Add a sequence - Basic example.ktr
├── Add sequence - specify a common counter.ktr
├── Aggregate - basics.ktr
├── Analytic Query - Lead One Example.ktr
├── Analytic Query - Random Value Example.ktr
├── Append streams - Basic example.ktr
├── Automatic Documentation Output - Generate Kettle HTML Documenation.ktr
├── Calculator - Substract constant value one from a number.ktr
├── Check if a column exists - Basic example.ktr
├── Clone row - Basic example.ktr
├── Closure generator - standard mondrian sample.ktr
├── Combination Lookup - Create new ids.ktr
├── CSV Input - Reading customer data.ktr
├── CSV Input - Reading customer data with error logging.ktr
├── Database - generic driver usage.ktr
├── data-generator
│   ├── Generate customer data.ktr
│   ├── generate order data.ktr
│   ├── Generate product data.ktr
│   └── products-random.txt
├── Data Validator - all usecases with error handling.ktr
├── Data Validator - validate data against external reference data.ktr
├── Delay row - Basic example.ktr
├── Denormaliser - 2 series of key-value pairs.ktr
├── Denormaliser - capturing last state timestamp.ktr
├── Denormaliser - Data conversion and aggregation.ktr
├── Denormaliser - Simple example.ktr
├── DistinctCount.ktr
├── Encrypt Password.ktr
├── Excel and Row Normaliser - basics.ktr
├── Excel Input - XLS - XLSX - ODS reading.ktr
├── Excel Output - Write different data types.ktr
├── Exchange_lastname_firstname.ktr
├── Execute a job in a transformation.ktr
├── Execute a transformation stored in a String.ktr
├── File exists - VFS example.ktr
├── files
│   ├── changelog.txt
│   ├── closure_input.txt
│   ├── coded-data.txt
│   ├── customers-100.txt
│   ├── customers-100-with-errors.txt
│   ├── Denormaliser - 2 series of key-value pairs.txt
│   ├── example.xml
│   ├── Excel and Row Normaliser - sample data.xls
│   ├── GetXMLData - test 1 - simple functionality test.xml
│   ├── GetXMLData - test 2 - missing elements.xml
│   ├── GetXMLData - test 3 - error handling.xml
│   ├── group-denormalize.txt
│   ├── hl7_message_01.txt
│   ├── hl7_message_02.txt
│   ├── hl7_message_wrongCRLF.txt
│   ├── hl7_message_ZBE_sample.txt
│   ├── Invoice_Statements.prpt
│   ├── Invoice.yaml
│   ├── item_detail.xml
│   ├── job-mail.png
│   ├── jsonfile.js
│   ├── JSON - read nested fields.js
│   ├── merge1_dups.txt
│   ├── merge1.txt
│   ├── merge2_dups.txt
│   ├── merge2.txt
│   ├── Pentaho Translator.png
│   ├── process and move files.png
│   ├── sales_data.csv
│   ├── sample-export.xml
│   ├── sample-file.ods
│   ├── sample-file.xls
│   ├── sample-file.xlsx
│   ├── Semicolon delimited.txt
│   ├── Spoon Metadata Search.png
│   ├── Switch-Case - test data for contains mode.txt
│   ├── Territories.txt
│   ├── test_xml_file.xml
│   ├── Textfile input - fixed length sample data.txt
│   ├── WebServicesMovieListingAsHTTP_SOAPRequest.xml
│   ├── XBase - dBase sample data.dbf
│   ├── XML Add - creating multi level XML files.xls
│   ├── XML file with substitutes.xml
│   ├── XML - flat.xml
│   ├── XML Input Stream (StAX) Test 1 - Basic Tests.xml
│   ├── XML Input Stream (StAX) Test 2 - Element Blocks.xml
│   ├── XML Input Stream (StAX) Test 3 - Attribute Groups.xml
│   ├── XML Input Stream (StAX) Test 4 - Hierarchies.xml
│   ├── XML Input Stream (StAX) Test 6 - Namespaces.xml
│   └── Zipssortedbycitystate.csv
├── Fixed Input - fixed length reading .ktr
├── General - Annotated SOAP Web Service call.ktr
├── General - Change log processing 2.ktr
├── General - Change log processing.ktr
├── General - check Sequence and Abort.ktr
├── General - Copy Data.ktr
├── General - Load images and store into database table.ktr
├── General - parallel reading and aggregation.ktr
├── General - parsing coded data.ktr
├── General - Populate date dimension AU.ktr
├── General - Populate date dimension.ktr
├── General - Repeat fields - Group by - Denormalize.ktr
├── General - replace a series of codes in a field.ktr
├── General sample - first and average coordinates calculation.ktr
├── Generate random value - all usecases.ktr
├── Generate Row - basics.ktr
├── Get File Names - Remove extension from short filename.ktr
├── Get File Names - Remove extention.ktr
├── Get Files - Get all transformations.ktr
├── Get System Info - Command Line Argument and filter.ktr
├── Getting Started Transformation.ktr
├── GetXMLData - Basic reading flat XML.ktr
├── GetXMLData - Differents Options.ktr
├── GetXMLData - large files.ktr
├── GetXMLData - Read parent children rows.ktr
├── Group By - Calculate standard deviation.ktr
├── Group by - include all rows and calculations .ktr
├── Group By - include all rows without a grouping.ktr
├── HL7_fixedCRLF.ktr
├── HL7_test_multiple_files.ktr
├── HL7_Z-Segments.ktr
├── HTTP Client - simple retrieval example.ktr
├── j
│   ├── Read a twitter stream.ktr
│   └── Twitter JSON parsing and hashtag aggregation.ktr
├── Java Filter - Conditional expression syntax example.ktr
├── Java Filter - Working with booleans.ktr
├── Java Filter - Working with string values.ktr
├── JavaScript - Access database connection metadata.ktr
├── JavaScript - Access environment variables.ktr
├── JavaScript - Add 2 and a half seconds to a Date.ktr
├── JavaScript - Base64 Decoder and Encoder.ktr
├── JavaScript - create new rows.ktr
├── JavaScript - date to string conversion.ktr
├── JavaScript - dialog.ktr
├── JavaScript - extract date from filename.ktr
├── JavaScript - Get the filename from a path.ktr
├── JavaScript - Hex to Integer conversion.ktr
├── JavaScript - parse Debet-Credit prefix in numbers.ktr
├── JavaScript - Parse XML.ktr
├── JavaScript - process all fields per row.ktr
├── JavaScript - replace values in a string with other values.ktr
├── JavaScript - Skip rows after x rows.ktr
├── JavaScript - Split String.ktr
├── JavaScript - String to Number to String conversion.ktr
├── JavaScript - Strip line feeds from text.ktr
├── JavaScript - truncate a date.ktr
├── Join Rows - adding fields to a stream.ktr
├── JsonInput - read a dynamic file.ktr
├── JsonInput - read a file.ktr
├── JsonInput - read incoming stream.ktr
├── JSON - read nested fields.ktr
├── luciddb - custom example1.ktr
├── luciddb - insert example1.ktr
├── luciddb - merge example1.ktr
├── luciddb - update example1.ktr
├── Memory Group By - simple example.ktr
├── Memory Usage getPercentageFreeMemory.ktr
├── Merge Join - Join 2 sorted data sets.ktr
├── Merge rows - mergs 2 streams of data and add a flag.ktr
├── Metadata injection - read a CSV file.ktr
├── meta-inject
│   ├── read_csv_file.ktr
│   └── use_metainject_step.ktr
├── output
│   ├── invoice_output.pdf
│   └── XMLOrders.xml
├── Pentaho Reporting Output Example.ktr
├── ProcessID.ktr
├── Properties output - normalising data before output.ktr
├── Regex Eval - parse NCSA access log records.ktr
├── Replace in string - Simple example.ktr
├── Repository Export.ktr
├── Repository Import.ktr
├── Row Normaliser - turn a single row into 3 rows.ktr
├── Row Normalizer - Simple example.ktr
├── SAP Input Basic 2.ktr
├── SAP Input Basic.ktr
├── SAP Input Tables.ktr
├── Select Values - copy field values to new fields.ktr
├── Select values - some variants.ktr
├── Servlet Data Example.ktr
├── Split field to rows - basic example.ktr
├── SQL File Output - Basic example.ktr
├── Step Meta Structure - Examine the structure of a data stream.ktr
├── Stream lookup - basics.ktr
├── String date with time to Date using metadata conversion.ktr
├── Switch-Case - basic sample.ktr
├── Switch-Case - contains example.ktr
├── Switch-Case - substring example.ktr
├── Table Output - Tablename in field.ktr
├── Textfile input - fixed length.ktr
├── Text File Output - Number formatting.ktr
├── TextInput and Output using variables.ktr
├── Unique - Case insensitive unique.ktr
├── Unique - Duplicate.ktr
├── Unique Rows by Hashset - basic example.ktr
├── User Defined Java Class - Calculate the date of Easter.ktr
├── User Defined Java Class - Concatenate firstname and lastname.ktr
├── User Defined Java Class - Query the database catalog.ktr
├── User Defined Java Class - Real-time search on Twitter.ktr
├── Value Mapper - Same and new field.ktr
├── VFS Configuration Sample.ktr
├── Web Services - Currency Converter.ktr
├── Web services lookup - convert degrees Celsius to Farenheit.ktr
├── WebServicesMovieListingAsHTTP.ktr
├── Web Services - NOAA Latitude and Longitude.ktr
├── XBase - dBase.ktr
├── XML Add - creating multi level XML files.ktr
├── XML Add - encode fields in XML and add the field.ktr
├── XML Add - Set attribute in specific element.ktr
├── XML file with substitutes.ktr
├── XML Input - basic reading flat XML.ktr
├── XML Input Stream (StAX) Test 1 - Basic Tests.ktr
├── XML Input Stream (StAX) Test 2 - Element Blocks.ktr
├── XML Input Stream (StAX) Test 3 - Attribute Groups.ktr
├── XML Input Stream (StAX) Test 4 - Hierarchies.ktr
├── XML Input Stream (StAX) Test 5 - Performance Test Data for Element Blocks.ktr
├── XML Input Stream (StAX) Test 6 - Namespaces.ktr
├── XML Join - Create a multilayer XML file.ktr
└── YAML - Read file.ktr

22 directories, 250 files