Stack Overflow
Stack Overflow

Questions tagged [pentaho-spoon]

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Documentation: http://wiki.pentaho.com/display/EAI/Spoon%2BUser%2BGuide

828 questions
0
votes
1 answer

How to launch two jobs simultaneously after the execution of one Job in Pentaho

I have a Main Pentaho job that has three jobs Job1, Job2 and Job3 in it. I want to execute Job2 and Job3 as soon as Job1 is finished. I tried to do it, but Pentaho executes Job2 first and then Job3 in the last. Is there any way that both the jobs…
Ujjwal Chowdary
  • 125
  • 2
  • 5
  • 18
0
votes
0 answers

How to execute sql script in pentaho and store in xml.

I have a requirement where I need to run a sql script containing multiple select statement and then to store in a xml file using pentaho. I need to do this using command line as a cron job will initiate the execution of sql script. I tried using…
Akhilesh
  • 11
  • 4
0
votes
5 answers

(Pentaho PDI):Thread: Couldn't find starting point in this job

Pentaho running job through command line I have a pentaho job which runs successfully in pentaho but if i try to run the same through command line i get the error -(But It runs Successfully in one PC throws, error in another PC) Here is my problem…
ANURAG
  • 1
  • 1
  • 2
0
votes
1 answer

I have Oracle Join query that picks data very slow

I have an Oracle join query that picks data very slow. It is like 1000 rows for 7 mins. Please could you help in writing the code in a different way so the data is pulled faster. The next steps for it is using the Select values and dumping the data…
Ujjwal Chowdary
  • 125
  • 2
  • 5
  • 18
0
votes
3 answers

How to use Pentaho Spoon to rename files that do not have an extension

I am new to using Pentaho Spoon. I have about 100 text files in a folder, none of which have file extensions. I have found that if I create a job and move a file, one at a time, that I can simply rename that file, adding a .txt extension to the…
FunkyLikeLeeDorsey
  • 3
  • 1
  • 4
0
votes
1 answer

I am getting a DB collation error when loading data

Hi I am loading the data from MySQL staging to MySQL destination. I get this error and it says Illegal mix of collations (latin1_swedish_ci, COERCIBLE) and (latin1_german1_ci, COERCIBLE) for operation '=' Does this has to do anything with Pentaho.…
Ujjwal Chowdary
  • 125
  • 2
  • 5
  • 18
0
votes
2 answers

Need to Replace in string with pentaho

I have to replace a part of strings in fields rows. Perhaps if anybody have some knowledge about using the replace in string with pentaho. string to replace:
neofito
  • 3
  • 1
  • 4
0
votes
1 answer

Pentaho Kettle - "Text File Output" order of write?

If multiple files are to be written to? Does Pentaho's "Text file Output" guarantee the records to be written in the order of what is sent to it? Or while dealing with multiple files and multiple streams, it has some internal logic which might…
Sushant kunal
  • 341
  • 1
  • 2
  • 9
0
votes
1 answer

Pentaho Spoon displays many errors in console

Pentaho Spoon displays many errors like this in console: (SWT:12688): GLib-GObject-WARNING **: /build/glib2.0-7IO_Yw/glib2.0-2.48.1/./gobject/gclosure.c:724: unable to remove uninstalled invalidation notifier: 0x7f1f2a537bc0 (0x7f1f6d5af530) The…
Franc Drobnič
  • 985
  • 10
  • 14
0
votes
1 answer

Pentaho | How to make CURL request in Pentaho

I have one URL. I want to log in into that URL and download the xml file from that URL link. File should be automatically downloaded. Like in PHP, we have CURL call which send request to URL and download the data. Do we have anything like this in…
Nilesh Patil
  • 91
  • 2
  • 11
0
votes
1 answer

How to transform to Entity Attribute Value (EAV) using Spoon Normalise

I am trying to use Spoon (Pentaho Data Integration) to change data that is in typical row format to Entity Attribute Value format. My source data is as follows: My Normaliser is setup as follows: And here are the results: Why is the value for the…
jzacharuk
  • 2,058
  • 1
  • 16
  • 22
0
votes
1 answer

pentaho: how to pass a variable in start-job from the lowest transformation

I am new at pentaho and have some problems during building my job. I have job1, which consists of job2 and other transformation. Job2 contains 3 transformations: 1, 2 and 3. The transformation3 makes some steps and calls another transformation4…
Jane
  • 23
  • 2
  • 5
0
votes
1 answer

About component "Note" : how should I use the "Raise" and "Lower" options

I'm using Pentaho DI ETL from a few weeks ago, and as in Talend DI ETL, there is the possibility to use a component "Note". This is quite useful to distinguish the main features of a job, and bring more informations at the first overview when…
Kapusch
  • 287
  • 1
  • 13
0
votes
2 answers

PDI Timestamp : Unable to get timestamp from resultset at index 5

I have a transformation in PDI which basically read data from amazon S3 bucket and push data into mysql database.But today i am facing below error in PDI in time of transformation execution. org.pentaho.di.core.exception.KettleDatabaseException:…
Zaynul Abadin Tuhin
  • 31,407
  • 5
  • 33
  • 63
0
votes
0 answers

Debug pentaho spoon plugin using Eclipse

I am trying to debug a plugin developed in Eclipse for Pentaho spoon / kettle. if anyone is aware of how to do this i would be pleased to learn. i have googled a lot and found this as most useful reference if someone can make it…
Adi
  • 11
  • 4
1 2 3
…
55 56