See also Language and Use of Indexes in Oracle /* DROP TABLE t ALTER SESSION SET NLS_LANGUAGE='AMERICAN' */ SELECT PARAMETER, VALUE FROM V$NLS_PARAMETERS CREATE TABLE t (x VARCHAR2(255)) INSERT INTO t VALUES ('a') INSERT INTO t VALUES ('b') INSERT INTO t VALUES ('c') INSERT INTO Language and Use of Indexes in Oracle This post demonstrates influence of characterset on use of indexes. Posted November 5th, 2011 by dmytro & filed under Kettle, Oracle. The source table JobEntry has two grouping fields project_id and employee_id and one additive measure registered_hrs. Let's assume the original transformation loading delta is the following: It reads data from source database, makes some transformations and loads data into data warehouse.
This post demonstrates an example how to create aggregation tables in Kettle.
Posted November 12th, 2011 by dmytro & filed under Kettle, SQL Server. The list is loaded into a Creating Aggregate Tables There is a list of contact persons in a source system. This post describes how the removal of records can be handled in dimension tables. The records can be removed from a table in a operational system, but we never remove records from dimension tables. Posted February 17th, 2012 by dmytro & filed under Kettle. You can get Handling Records Removal in Dimension Tables You can write: kitchen.bat /rep repos /job test /user admin /pass admin but this will not work: kitchen.bat /rep repos /job test /user admin /pass "Encrypted 2be98afc86aa7f2e4cb79ce71da9fa6d4" Here "Encrypted 2be98afc86aa7f2e4cb79ce71da9fa6d4" is encrypted version of "admin". Pentaho Kettle does not provide possibility to obfuscate password in batch files (though the connection passwords are obfuscated in XML files). Posted March 21st, 2012 by dmytro & filed under Kettle.
And this trivial transformation failed with a weird error: Unexpected error : : MINUTE How to Obfuscate Password for Command Line Kettle Calculator calculates field DATE using operation "Remove time from a date". After simplification I got this: Generate Row creates one row with the date field DATETIME=. I encountered an error running a Pentaho Data Integration transformation. Posted February 19th, 2013 by dmytro & filed under Kettle. Create Removing time part of a date fails in Kettle
A solution is to archive old entries from the log table. When the log table gets large, opening a transformation may take long time and PDI freezes for this time. Pentaho Data Integration displays only the last 50 log entries but anytime you open a transformation it has to read the whole log table.
Posted January 14th, 2015 by dmytro & filed under Kettle, Maconomy. A solution might be to create a small java Archiving Pentaho log table in SQL Server However the format of the output depends on locale and it is almost not possible to make the script which runs on any machine. The usual approach to build a timestamp for a log files in a batch is to use standard Windows utilities date and time. Posted February 26th, 2015 by dmytro & filed under Java, Kettle. Posts Categorized: Kettle Format date in Batch yyyyMMdd