Skip navigation
Log in to follow, share, and participate in this community.

Recent Activity

Ana Gonzalez
After my question with a simple test had been answered, I've been working on complicating things, now I want to inject metadata to the Update step where I have to perform updates to different tables always with this structure: UPDATE MyTable SET MyColumn1 = value1,         MyColumn2 = value2 WHERE MyColumn3 = value3 AND MyColumn4 = value4  So I… (Show more)
in Data Integration
Lee Wesley
I have a MSSQL source database that constantly having new records coming in (it is a database of a POS system and each time a transaction is done a record is inserted), and also a data warehouse using PostgreSQL, where data are processed from source database and store here on an hourly basis, using pentaho spoon and kettle.   So, how can I… (Show more)
in Data Integration
Felipe Sedevitiz
Hello everyone,   I am with a problem with Json Input, i have the follow json structure:   {    "_id" : ObjectId("5bbe45b4d4fcde68c47c468c"),   "node" : <INT32>,   "url"     :<STRING>,    "destinations" : [                                        < ------------ ARRAY 1                                  {… (Show more)
in Data Integration
archana garikapati
trunc function in pentaho- calculator or formula step. legth and precision when given are not working  
in Data Integration
Swapnil Shelke
Hi,   I am importing an XML file using PDI and want to know the record number if there is any data error. I have enabled Rownum in Output but then the issue is that rownum is printed at the end and the data error will occur before that. So always in that error record, its null. Is there any way to change the sequence by bringing it to first… (Show more)
in Data Integration
Nikola Garafolic
I am using rest client to fetch data from api. Have to do thousands of requests, but using rest client results in poor performance (3-5 queries in a second) due to client not being persistent, but opening connection on every request.  What can be done other than using multiple rest client in parallel?  In rest client I use authorization and… (Show more)
in Data Integration
girish athanikar
 Hi Team,   I am have a issue which is kind of blockage for the work.Can you help me in resolving this. Basically I am running a transformation where in I am using a Job Executor step,to it I am feeding three different Id's which internally connects to different files.This can be better explained using an example. Let the three id's be… (Show more)
in Data Integration
preeti soni
hei, I want to know how to delete files based the creation date using a kettle job. I have a log folder which contains log files for last four years. But I want to keep files of 1st day of every month and delete files which are 60 days older and 12 months older. Step by step process I used to create kettle:   Get file name: Get system info: regex… (Show more)
in Data Integration
Load more items