US and Worldwide: +1 (866) 660-7555

Search Forums:

Type: Posts; User: gutlez; Keyword(s):

Page 1 of 52 1 2 3 4

Search Forums: Search took 0.19 seconds.

  1. Replies
    3
    Views
    91

    The Get System Info step *IS* passing data....

    The Get System Info step *IS* passing data.
    However the Table Input is not designed to pass incoming rows onwards, unless they included in the select statement.

    You can update it to do something...
  2. If it's a Tab delimited file, then all the TABs...

    If it's a Tab delimited file, then all the TABs in the file disappear, leaving the line as NULL.
  3. You are assuming that I have access to an Oracle...

    You are assuming that I have access to an Oracle system.
    I do not.

    Explain what you are trying to accomplish, since you seem to have jumped directly to solution, without working through the HOW...
  4. I'm not fully following how you are trying to do...

    I'm not fully following how you are trying to do what you're trying to do.

    The only part that should work from your Transform that should work as you expect it to would be the Max CDC -> Track...
  5. If you use the correct JDBC URL, then you will go...

    If you use the correct JDBC URL, then you will go JDBC -> Oracle directly.

    URL Format:
    http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#05_03

    Class Name:
    If...
  6. Replies
    1
    Views
    74

    Because the SQL Script step is not intended to...

    Because the SQL Script step is not intended to return a result.
    Try the Call DB Procedure step instead, or even the Table Input.
  7. Replies
    3
    Views
    91

    If I understand you correctly, you're doing Get...

    If I understand you correctly, you're doing Get System Info -> Table Input -> CSV Output
    Table Input isn't all that well known for passing data through.

    If you reorganize to Table Input -> Get...
  8. Use Oracle's Driver. Why would you convert JDBC...

    Use Oracle's Driver.
    Why would you convert JDBC to ODBC to Oracle when you can go directly JDBC to Oracle
    Secondly, Sun JDBC-ODBC Bridge is depreciated.
  9. It should be taking the repository name...

    It should be taking the repository name...
  10. Pavan, Work through the steps from...

    Pavan,

    Work through the steps from http://forums.pentaho.com/showthread.php?167105-kitchen-bat-always-complains-that-quot-the-job-couldn-t-be-loaded-quot&highlight=Couldn%27t+be+loaded#post381869...
  11. Thread: Product Cost

    by gutlez
    Replies
    2
    Views
    85

    You are really posting in the wrong forum for...

    You are really posting in the wrong forum for that.
    This forum is for the developers of the User Experience to discuss decisions on that user experience.

    Also if you are looking for cost &...
  12. I'm able to create the sample that you describe...

    I'm able to create the sample that you describe using 5.1 without a problem.
    I had to swap the table_output with a Text File Output, but that shouldn't be that big a difference.

    Perhaps if you...
  13. That doesn't surprise me much. A DB on localhost...

    That doesn't surprise me much. A DB on localhost is going to have a *HUGE* bandwidth (think in the ballpark of 8 Gbps) with very low latency (think in the ballpark of 30 microseconds), since it's a...
  14. Replies
    2
    Views
    299

    If you are using PDI Scheduler, that usually...

    If you are using PDI Scheduler, that usually indicates that you are using Enterprise Edition.
    If you are using Enterprise Edition, you will have a support contract.
    I would suggest contacting your...
  15. Not really - you could run your transformations a...

    Not really - you could run your transformations a second time in "Read Only" mode, and any Dimension that is not found would error out. Since the Dimension needs to know what table (and thus would...
  16. Yup, That's the nature of floating point. Try...

    Yup, That's the nature of floating point.

    Try converting them to Integers at the level of significance, (eg. FP# * 100 -> Integer) and compare those. We should probably file a feature...
  17. So are these for Dimension tables, or fact...

    So are these for Dimension tables, or fact tables?

    You can use the Combination Lookup / Update step (in Lookup only mode) to look up dimension keys, and to throw an error if they don't already...
  18. Based on the output you show, 2.6s - 4.6s for the...

    Based on the output you show, 2.6s - 4.6s for the lookups, I would guess that the bottleneck is in the lookups.

    You could try improving the indexes on the lookup tables, or you could try...
  19. What's the intended end goal? It feels like you...

    What's the intended end goal?
    It feels like you are only giving us part of the problem, and anonymizing the input at the same time. This has lead in the past to very inefficient solutions to the...
  20. What is your intended output? IN: Row |...

    What is your intended output?

    IN:
    Row | String
    1 | red, WH_COLORS
    2 | blue, WH_COLORS
    3 | pizza, WH_FOOD
    4 | fish, WH_FOOD

    Out:
  21. Ok, so lets do some math... Table Input: At...

    Ok, so lets do some math...
    Table Input: At least 1 Round Trip to the DB, with a cursor left open to control the flow rate
    Lookup Step: 1 Round Trip to the DB for each row
    Lookup Step: 1 Round...
  22. Replies
    5
    Views
    171

    Do you have an Insert Timestamp and an Update...

    Do you have an Insert Timestamp and an Update Timestamp?
    If you do, then the usual method is:
    Transform 1:
    Table Input 1 (Select MAX(Insert Timestamp) from DestinationTable ) -> Table Input 2 (...
  23. Replies
    1
    Views
    87

    You might try contacting sales? Big "Contact Us"...

    You might try contacting sales?
    Big "Contact Us" button in the top right corner of this page, they might be able to offer such a comparison.
  24. Replies
    8
    Views
    171

    Not 100% If you have a complex table input...

    Not 100%
    If you have a complex table input statement, then the DB will do some of the hard work.
    If you send an update statement to the DB with Execute SQL Row, then the DB is doing the work.
    ...
  25. Perhaps you can define "Slow" What else is going...

    Perhaps you can define "Slow"
    What else is going on in the transformation? Other steps can impact how fast data is loaded into the DB.
    If your transform is only doing "Text File Input" -> "Table...
  26. Replies
    2
    Views
    459

    Have you double checked that no elements overlap?...

    Have you double checked that no elements overlap?
    Overlapping elements will cause the issue you are seeing.
  27. Replies
    8
    Views
    171

    for the most part, we recommend people perform...

    for the most part, we recommend people perform things as "Extract Transform Load", but with some of the steps available, you can do "Extract Load Transform" (within table constraints)
  28. The community standard answer for scheduling is...

    The community standard answer for scheduling is native OS Scheduling (Unix/Mac -> cron, Windows -> Windows Scheduled Events) as per...
  29. Replies
    4
    Views
    129

    Current lines: %_PENTAHO_JAVA% is set by...

    Current lines:

    %_PENTAHO_JAVA% is set by set-pentaho-env.bat
    This will look for %JAVA_HOME% which seems to not be set on your system, so it is coming back as null.
    It tries to run...
  30. Could the servers be in different timezones? (Not...

    Could the servers be in different timezones? (Not necessarily physical, but OS settings...)
    ie. Server A (the initial Table Input) is in UTC, and Server B (the DB Join) is in UTC-4 ?
  31. Replies
    2
    Views
    120

    That probably factors in to the cause of the...

    That probably factors in to the cause of the problem.
    SOCKS server generally implies proxy
  32. Thread: Filter rows

    by gutlez
    Replies
    5
    Views
    157

    Or even the "Filter Rows" step with a Field...

    Or even the "Filter Rows" step with a Field matches REGEX configuration...
  33. Not necessarily the exact same problem, but yes,...

    Not necessarily the exact same problem, but yes, others have experienced it.
    Response has been that UNC path is not officially supported - it may work, it may not, don't trust it.
  34. Honestly, your Tomcat should be supplying a JNDI,...

    Honestly, your Tomcat should be supplying a JNDI, rather than using simple-jndi.
  35. Replies
    1
    Views
    101

    PDF supports having Hyperlinks in it, so Pentaho...

    PDF supports having Hyperlinks in it, so Pentaho puts the links in.

    Since you don't want the links, you could wrap your Hyperlink function with an IF statement to check the output type.

    If it...
  36. For ease of understanding, you *COULD* (note, I'm...

    For ease of understanding, you *COULD* (note, I'm not saying SHOULD...) use a switch case for pricing_quote and redirect to three select values steps. One that copies discount_line ->...
  37. Lal is close... If I remember correctly,...

    Lal is close...

    If I remember correctly, Oracle doesn't let you access datetimes directly - it converts them to Strings (Remember: "August 29, 2014 9:15 AM PST" is a string, not a datetime)
  38. Replies
    5
    Views
    161

    That's what I'm suggesting :D

    That's what I'm suggesting :D
  39. Replies
    5
    Views
    147

    Java time is only resolved to milliseconds....

    Java time is only resolved to milliseconds.
    There's not a lot out there that can measure microseconds accurately.

    You could TRY getting Oracle to change the Java standard to support microseconds,...
  40. yes. Execute SQL row script....

    yes.
    Execute SQL row script.
    http://wiki.pentaho.com/display/EAI/Execute+row+SQL+script
  41. Replies
    5
    Views
    147

    What are the other 4 digits for? millisecond =...

    What are the other 4 digits for?
    millisecond = 1/1000th of a second, so there should only be 2012-01-19 15:10:02.123
    with .123 it works.

    so... What are the other 4 digits?
  42. Have a peek at the "Execute Row SQL script" step.

    Have a peek at the "Execute Row SQL script" step.
  43. Replies
    5
    Views
    147

    Try adding .S to the end (ie. yyyy-mm-dd...

    Try adding .S to the end (ie. yyyy-mm-dd hh:mm:ss.SSS)
    http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html
  44. Actually, it more likely means that people found...

    Actually, it more likely means that people found the other posts on the forum that state clearly that the code is on Github

    https://github.com/pentaho
  45. Usual practice with CE is to put the files into...

    Usual practice with CE is to put the files into place on your production system using Version Control (git, svn, etc) and schedule the job/transform using the native OS tools (cron, Windows Scheduled...
  46. Replies
    5
    Views
    161

    Most SQL Server variants are supported by the...

    Most SQL Server variants are supported by the jTDS Driver. Anything else can be accessed with MS's version. They use completely different JDBC URLS, so you should be able to work around the issue...
  47. Replies
    3
    Views
    175

    If you have a database, why would you not use the...

    If you have a database, why would you not use the DB lookup, the Dimension lookup, or Combination lookup steps?
  48. Replies
    8
    Views
    148

    Sorry, I meant JARs (MySQL JDBC Jar, etc) which...

    Sorry, I meant JARs (MySQL JDBC Jar, etc) which are stored in <PDI Install Directory>/lib

    Are you using hostnames in the LOGDB configuration, or simple-jndi, or shared configs, or ... ?...
  49. Check all your JARs - you may have a JAR that is...

    Check all your JARs - you may have a JAR that is being called in the Transform that you don't have in PRD.

    That's about all I can come up with off the top of my head. :(
  50. Replies
    8
    Views
    148

    If your PDI versions are the same, and you have...

    If your PDI versions are the same, and you have the same libraries install on each machine (watch out for MySQL, it's odd!), then spoon and pan behave the same.
Results 1 to 50 of 2581
Page 1 of 52 1 2 3 4