kettle
Merging a stream with table input records NOT in the stream
I am trying to pull together a complex Kettle transformation on a set of patient data.I have several table input steps that query a MySQL table that assembles patient rows into a stream.Each table inp[详细]
2023-01-29 15:19 分类:问答Pentaho Kettle - batch script doesn't produce output
I\'ve written a very simple pentaho kettle script that works fine when I launch it from the spoon ide. It takes in a csv file and writes it to a text file and an xml file. However, if I run it as a ba[详细]
2023-01-26 15:03 分类:问答Pentaho kettle : how to execute "insert into ... select from" with the sql script step?
I am discovering Pentaho DI and i am stuck with this problem : I want to insert data from a csv file to a custom DB, which does not support the \"insert table\" step. So i would like to use the sql[详细]
2023-01-24 23:11 分类:问答Pentaho: Best way to convert a date into a drill-down-able cube dimension?
My datawarehouse table just contains a single date SQL column, but I want to be able to drill down开发者_高级运维 using the usual year/quarter/month/day levels.[详细]
2023-01-11 10:27 分类:问答Recursive calls in Pentaho Data Integration
Is it possible for a step or trans开发者_开发百科formation in Pentaho Data Integration to call itself, passing the results of the previous call as parameters/variables?[详细]
2022-12-22 01:08 分类:问答Rhino ETL opinions vs Kettle and SSIS [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely solicit debate, a[详细]
2022-12-21 11:48 分类:问答Reading both attributes and nodes at the same time in Kettle / Spoon
I\'m using kettle and trying to load both the attribute and node values from an xml document. <Colors>[详细]
2022-12-16 02:05 分类:问答Where is Pentaho Kettle's architecture?
Where can I find Pentaho Kettle architecture? I\'m looking for a short wiki, design document, blog post, anything to give a good overview on how things work. This question is not meant for specific \"[详细]
2022-12-08 09:39 分类:问答