|
More site info...
Pentaho Data Integration [Kettle] | Forum profile
|
|
Forum profile page for Pentaho Data Integration [Kettle] on http://www.pentaho.org.
This report page is the aggregated overview from a single forum: Pentaho Data Integration [Kettle], located on the Message Board at http://www.pentaho.org.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Pentaho Data Integration [Kettle]" on the Message Board at http://www.pentaho.org is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Pentaho Data Integration [Kettle]:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
99
|
341
|
910
|
|
Post:
|
202
|
794
|
2,222
|
|
|
Pentaho Data Integration [Kettle] Posting activity graph:
|
Top authors during last week:
user's latest post:
Help with simple evaluation
Published (2009-11-26 17:44:00)
There's really not a lot to work with here.... Can you post the config of your Simple Eval entry?
MattCasters Chief Data Integration
12
user's latest post:
Database Locked
Published (2009-11-20 06:36:00)
That sounds highly unlikely vlr. A query doesn't (or shouldn't) perform an exclusive lock on any table. Obviously, the query will remain open until you stop it. That's what the "Stop" button is for...
user's latest post:
Migration Kettle 3.0.1 > 3.2.0
Published (2009-11-23 06:12:00)
Make a backup of the repository. Migrate the repository (there should be some info about that in the Install notes) Install Spoon whereever you like run Spoon Be aware that changes in the repository structure or content took place and you will have to update all instances of PDI (spoon, kitchen, pan).
billabang Junior Member
10
user's latest post:
Question about steps with...
Published (2009-11-23 07:09:00)
Thanks Gutlez. I knew it kind of made sense but wondered if this was definitely the desired result. I figured when you made copies of a step it would share the rows but I was obviously wrong. No problem anyway. Cheers again!
user's latest post:
Java 64 Bits
Published (2009-11-18 12:25:00)
I am using version PDI 3.2. Regards, Quote: Originally Posted by rocaver I execute spoon.bat and nothing happends, I modify spoon.bat and create spoon2.bat (setting the classpath directly) and a lot of rubbish comes out the command screen but PDI does not open. Suggestions? Regards, Ben
user's latest post:
A couple of questions
Published (2009-11-23 04:38:00)
Hi Guys, Quote: Checkbox at the bottom of the input mapping step to include unspecified rows. Try turning that off. Thanks for the feedback and taking the time. With the mapping input step I have the [Include unspecified fields, ordered by name] unchecked. I also only have the one field specified in the input tab of the mapping step, matched to the same field name, type, length, precision specified in the input specification. Still getting the...
user's latest post:
EC2 Pentaho
Published (2009-11-25 06:18:00)
Just create an AMI on your favorite Linux distribution: 1) Start up a Carte server during boot (/etc/init.d/carte) 2) Accepts an input file from the ec2-start-instances command Then you can start up a master server + N slave servers like this: http://www.ibridge.be/?p=160 __________________ Matt Casters , Chief Data Integration Pentaho, Open Source Business Intelligence http://www.pentaho.org -- mcasters@pentaho.org Join us on IRC server...
user's latest post:
A couple of questions
Published (2009-11-20 08:47:00)
Quote: Originally Posted by TheFrog - [Modified Javascript Value] step (with compatability mode turned off) seems to be not handling data being returned to an existing stream field via the .setValue function. I am seeing that when using the output_field.setValue(var) that the 'function' .setValue does not exist for object output_field. I set up a JS variable, set its value then called the output function and saw the error message. I...
sraghvendra Junior Member
3
user's latest post:
Common Database connection For...
Published (2009-11-19 08:08:00)
I am new to Kettle as well. In Informatica they have a facility for achieving something similar. Here, I am not quite sure if they have it or how to achieve it. would be nice to know though...
|
|
|
|
Latest active threads on Pentaho Data Integration [Kettle]::
Started 5 days, 7 hours ago (2009-11-23 06:02:00)
by fabianS Senior Member
Sort the data and use the GROUP BY step. Check the 'unique rows' check-box.
This should help.
Started 1 day, 5 hours ago (2009-11-27 07:43:00)
by Bart.Farasyn Member
Hi Leon,
If you want a rollback in the same transformation, set "use unique connection" to true.
You can find this option in Transformation setting | Miscellaneous.
If you have to rollback more than one transformation, you have to implement that yourself (keep track of your changes in a separate table and use this to undo what was allready commited)
Hope this helps
Groeten,...
Started 1 day, 19 hours ago (2009-11-26 17:44:00)
by gutlez Senior Member
There's really not a lot to work with here....
Can you post the config of your Simple Eval entry?
Started 2 days, 5 hours ago (2009-11-26 08:15:00)
by anonim Junior Member
I thought about using field to rows splitter component, but I had (and still have no idea) no idea what to do next with these rows.
Maybe someone could tell me necessary steps. I have used php for data loading some time ago, but I would like to go the hard way, i.e. use PDI.
Started 23 hours, 12 minutes ago (2009-11-27 14:06:00)
by leomuler Member
You can use a getDate() step and after a Calculator to search a month. It´s easier .
Léo
Started 1 day, 2 hours ago (2009-11-27 10:56:00)
by Bart.Farasyn Member
Hi Bjoern,
If you mean that you get the "I couldn't find any fields" when you click on "Show input fields".
This is perfectly normal because your table input is the first step of the transformation, so it is not getting any fields from a previous step.
That is what the "show input fields" tells you.
Groeten,
Bart
Started 1 day, 7 hours ago (2009-11-27 05:19:00)
by TheFrog Senior Member
You need to populate your dimension tables first, and you must do them completely. By this I mean you must have all required values in the dimension tables before you try and populate anything in the fact table.
Once the dimension tables are populated from whatever source data you are using, you can start to load a fact table. Typically you would want to 'match' you incoming fact data to the ...
|
|
Hot threads for last week on Pentaho Data Integration [Kettle]::
Started 1 week, 1 day ago (2009-11-20 09:57:00)
by billabang Junior Member
Hi
When you set a step to have multiple start copies and have a stream coming into it where the previous step only has one output, by default the rows get shared between each copy of the step.
However if you create a second output stream to another step from the previous step it asks you if you want to copy or distribute.
OK I want to copy as I want all rows to go to both steps....
Started 1 day, 19 hours ago (2009-11-26 17:44:00)
by gutlez Senior Member
There's really not a lot to work with here....
Can you post the config of your Simple Eval entry?
Started 1 week, 4 days ago (2009-11-16 21:35:00)
by gutlez Senior Member
**NOT TESTED**
Use a couple of table inputs, and a Dimension Lookup / Update
TI1: Select Max(Date_From) from SCD_Table
TI2: Select * from INPUT_Table where UpdateDate > ?
DLU: Output to SCD_Table, stream date field = UpdateDate
Is that sufficient?
Since on the initial run, Max(Null) should come back to either null or 0, you can put a little extra logic in there and make it work ...
Started 1 week, 1 day ago (2009-11-20 08:47:00)
by bugg_tb
Quote:
Originally Posted by TheFrog
- [Modified Javascript Value] step (with compatability mode turned off) seems to be not handling data being returned to an existing stream field via the .setValue function. I am seeing that when using the output_field.setValue(var) that the 'function' .setValue does not exist for object ...
Started 1 week, 1 day ago (2009-11-19 20:04:00)
by gutlez Senior Member
Can't really help you, but it might be related to:
http://support.microsoft.com/kb/263889
Started 2 days, 5 hours ago (2009-11-26 08:15:00)
by anonim Junior Member
I thought about using field to rows splitter component, but I had (and still have no idea) no idea what to do next with these rows.
Maybe someone could tell me necessary steps. I have used php for data loading some time ago, but I would like to go the hard way, i.e. use PDI.
Started 1 week, 2 days ago (2009-11-19 08:08:00)
by sraghvendra Junior Member
I am new to Kettle as well. In Informatica they have a facility for achieving something similar.
Here, I am not quite sure if they have it or how to achieve it.
would be nice to know though...
Started 1 week ago (2009-11-20 16:33:00)
by crouse crouse is offline Junior Member
Be Kind, I'm new, and I have searched the forums...
MS Sql Server Uniqueidentifiers (GUID) and Pentaho don't seem to want to work together very well.
I'm able to retrieve a field defined as GUID by casting it as varchar in the sql, not a big issue.
But since most all the tables are PK'd by the GUID, I'll have to do a lot of database lookups on the GUID.
My problem is: how do...
Started 5 days, 7 hours ago (2009-11-23 06:02:00)
by fabianS Senior Member
Sort the data and use the GROUP BY step. Check the 'unique rows' check-box.
This should help.
Started 3 days, 1 hour ago (2009-11-25 11:58:00)
by codek Senior Member
i'm not sure, but i dont think PATH = java.library.path
you need to make sure your dll is on the java lib path as well.
|
|
![Pentaho Community Forums - Pentaho Data Integration [Kettle]](http://icons.boardreader.com/5e/81/5e81c0b836cd5680ca424a12bd2453d2.png){kind=icon}
Size: 108 bytes
![Customize "RE: Skip duplicate sequential records according to a key :: Pentaho Data Integration [Kettle] :: Pentaho Community Forums"](/images/cust_r0.gif "Customize \"RE: Skip duplicate sequential records according to a key :: Pentaho Data Integration [Kettle] :: Pentaho Community Forums\"")
