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

Search Forums:

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

Page 1 of 56 1 2 3 4

Search Forums: Search took 0.24 seconds.

  1. Did you initialize your Javascript variables?...

    Did you initialize your Javascript variables?
    You would be clearer for future maintenance if you used the PDI building blocks.
  2. Replies
    4
    Views
    111

    You would have to hack the Jackrabbit repository...

    You would have to hack the Jackrabbit repository to do that. Beyond that, I have no guidance for you.

    Short answer is: Not easily.
  3. Replies
    2
    Views
    90

    Please share your solutions. This allows the...

    Please share your solutions.
    This allows the whole community to learn. If you want the community to help you, you have to be willing to help the community too.
  4. Are you getting file name conflicts? If you...

    Are you getting file name conflicts?

    If you write two of those files to the same name, you would overwrite them, decreasing your count. I've done this to myself a few times.
  5. Replies
    6
    Views
    129

    So what did you do to solve it? SHARE your...

    So what did you do to solve it?
    SHARE your solutions - it makes it easier for others to help themselves!
  6. Replies
    3
    Views
    91

    Have a look at the chown command and the chmod...

    Have a look at the chown command and the chmod command in your Linux guides (they are not PDI/Spoon commands)
  7. Replies
    4
    Views
    105

    Try using the Select Values Meta Data tab to...

    Try using the Select Values Meta Data tab to convert the BigNumber to a Number.
    Then use that in your lookup.
  8. Options I can think of off the top of my head:...

    Options I can think of off the top of my head:
    1) look at the KETTLE_HOME environment variable, and what it can do for you.
    2) look at KFF
    3) Build your Jobs to read a properties file and set...
  9. Replies
    4
    Views
    174

    Or use the CTool to set session variables.

    Or use the CTool to set session variables.
  10. Calculator: NVL(A,B) ...

    Calculator:
    NVL(A,B)

    http://explainextended.com/2009/06/20/nvl-vs-coalesce/
  11. Thread: Process

    by gutlez
    Replies
    5
    Views
    162

    If you dig around a bit, you will find a lot of...

    If you dig around a bit, you will find a lot of information on how to parallelize Transform Entries.

    Transforms are where ETL work actually happens. If you want to improve throughput, you need to...
  12. In a PDI forum, you can expect that we're talking...

    In a PDI forum, you can expect that we're talking about PDI jobs. To run xactions, you need to install and configure BIServer, and learn how to build the kickoff xactions. Xaction is depreciated in...
  13. Chris, Honestly, for PDI CE, your *BEST*...

    Chris,

    Honestly, for PDI CE, your *BEST* method is to use your native OS scheduling tools, and keep your files in the KTR/KJB format.
    You can use git or svn to manage versions of the files,...
  14. Try not saving it in a repository.

    Try not saving it in a repository.
  15. Are you using a repository? Repository does...

    Are you using a repository?
    Repository does interesting things to the Internal Directoryname variables.

    Have you saved the Job?
    If you haven't, it becomes a bit of a "Schrödinger" question: "If...
  16. Or alternatively,...

    Or alternatively, https://code.google.com/p/kettle-franchise/
  17. Thread: Process

    by gutlez
    Replies
    5
    Views
    162

    You are still not explaining WHY? You can do...

    You are still not explaining WHY?

    You can do parallelization at the Transform level, and improve your throughput by a lot more.
  18. Thread: Process

    by gutlez
    Replies
    5
    Views
    162

    Why are you trying to do the parallelization at...

    Why are you trying to do the parallelization at the Job level?

    Also, please make sure you use referential links in your examples ( ie. ${Internal.Job.Filename.Directory}\tr_parallel2.ktr rather...
  19. Replies
    11
    Views
    161

    Add a dummy step after the Table Output, and when...

    Add a dummy step after the Table Output, and when making the hop from Table Output to Dummy, select "Error Handling of Step"
    This should set up basic error handling

    This Dummy step should now...
  20. This is likely your problem... Try looking at...

    This is likely your problem...

    Try looking at the MySQL Bulk Load step, since Insert does a round-trip to the DB for each row. You can also choose to keep building out (multiple connections)...
  21. Replies
    10
    Views
    185

    Then the suggested fix might not work... What...

    Then the suggested fix might not work...

    What I would suggest is commission an InfiniDB Bulk Load step that streams into the same protocol that their File Load uses.
  22. Replies
    11
    Views
    161

    Right click on Table Output and select "Define...

    Right click on Table Output and select "Define Error Handling" (Second from the bottom on my context menu)
  23. Replies
    11
    Views
    161

    Can you change the model? Table Input1:...

    Can you change the model?

    Table Input1:
    Select max(update_date8), max(update_time6) from tgt

    Table Input2:
    Select * from src where update_date8 > ? and update_time6 > ?

    Table Output:...
  24. I can't say for sure, but I bet that it has to do...

    I can't say for sure, but I bet that it has to do with the file being in memory after the copy.

    Try moving the file to the network drive, delete the DB.Cache (%userprofile%\.kettle\db.cache* ),...
  25. I read that to mean that you are only providing...

    I read that to mean that you are only providing one parameter.
    The number of ?'s and the number of incoming columns MUST match.
  26. Replies
    10
    Views
    185

    My point is... What is the point of adding the...

    My point is... What is the point of adding the filename into the the CSV?
  27. Replies
    2
    Views
    90

    What about handling it within the transformation...

    What about handling it within the transformation (write to a log file?)
    The transform would then succeed, and move on to the next file.
  28. Replies
    10
    Views
    185

    Text File Output ? But the question then...

    Text File Output ?

    But the question then becomes... WHY?

    Incoming-CSV-File1.csv gets updated with the filename as a column within it.
    Incoming-CSV-File1.csv gets renamed to...
  29. Replies
    10
    Views
    185

    http://wiki.pentaho.com/display/EAI/Text+File+Inpu...

    http://wiki.pentaho.com/display/EAI/Text+File+Input

    Additional Output Fields (tab)
    Short filename field

    Enter the column name there, and when PDI reads the file, it will include the filename...
  30. Replies
    6
    Views
    119

    What happens if you use an Update step (rather...

    What happens if you use an Update step (rather than an Insert/Update), and check the "Skip Lookup" checkbox?
  31. Replies
    6
    Views
    119

    No - based on your initial quote: ...

    No - based on your initial quote:


    Insert/Update decides which *COLUMNS* to update based on the first row, and then updates all rows with the matching keys
    The only way to know for certain is to...
  32. Replies
    3
    Views
    91

    It's pretty clear from the error message that the...

    It's pretty clear from the error message that the user running cron doesn't have access to the files.
  33. Replies
    6
    Views
    119

    Ok, so translating a little bit here... Say...

    Ok, so translating a little bit here...

    Say you have a table:
    TableKey | BusinessKey | Column 1 | Column 2
    1 | 1 | Something | Something Else
    2 | 1 | Yada Yada | Some New Data

    So your I/U...
  34. Well, if that's the only step you've added, then...

    Well, if that's the only step you've added, then things won't work. This is similar to putting just the dummy step on your canvas and trying to hit run.


    Yes, some members of the PDI community...
  35. Replies
    10
    Views
    524

    Also keep in mind that BIServer 4.8.0 and...

    Also keep in mind that BIServer 4.8.0 and BIServer 5.x are significantly different, and that what applies for 4.8.0 does not necessarily apply for 5.x
    Start right at the beginning and make one small...
  36. Replies
    2
    Views
    68

    It's possible that your 3rd party has used a...

    It's possible that your 3rd party has used a newer version of PDI than you have...
    What version are you running?

    It's also possible that the KTR file has issues due to the transfer (I've seen...
  37. Replies
    2
    Views
    98

    Analysis Report and Interactive Report are EE...

    Analysis Report and Interactive Report are EE features (Paid)

    You can install Saiku from the marketplace to get a feature similar to Analysis Report.
    I'm not sure what option there is for...
  38. Why not look at the answer given in a thread...

    Why not look at the answer given in a thread started less than a week ago?
    http://forums.pentaho.com/showthread.php?179904-Kettle-Java-API-in-a-software-product

    Short answer - You need to talk to...
  39. In spoon.bat or spoon.sh, find the line: set...

    In spoon.bat or spoon.sh, find the line:
    set OPT=%OPT% %PENTAHO_DI_JAVA_OPTIONS%

    Add
    -Ddb2.jcc.charsetDecoderEncoder=3
    to the end of it.

    Try it... I'm not promising that it will work -...
  40. Can you provide us one complete record to work...

    Can you provide us one complete record to work from?
  41. Replies
    3
    Views
    113

    Apparently "File" is also a start-process option,...

    Apparently "File" is also a start-process option, so it thinks you want the start-process command to use the file, rather than PDI.
    I'm not really sure how to fix that one...

    It looks like you...
  42. On FTP, there's no concept of drives... So you...

    On FTP, there's no concept of drives... So you have to say "Which folder within the FTP base directory do I want the files?"

    For example, if the FTP Service on your server is configured to...
  43. Replies
    5
    Views
    139

    Your bottom line ( Table 4 -> Party -> Merge Join...

    Your bottom line ( Table 4 -> Party -> Merge Join ) looks right to me.
    Now any places that you don't have a matching party reference will have holes in the data, but that's expected.
  44. From IBM: So, you have very bad data in your...

    From IBM:


    So, you have very bad data in your database. You will need to try to figure out which row has this bad data, and fix the data using another way (example: your Front-end).
  45. Replies
    5
    Views
    139

    So is this just a continuation of your existing...

    So is this just a continuation of your existing thread http://forums.pentaho.com/showthread.php?179769-XML-output-not-getting-in-CSV
  46. Replies
    4
    Views
    129

    Apparently it's a disagreement between the SWT...

    Apparently it's a disagreement between the SWT version in 5.2 and something in some of the versions of Linux. It works correctly on Windows.
  47. Replies
    4
    Views
    129

    Google says:...

    Google says:
    http://forums.pentaho.com/showthread.php?178836-Spoon-CRASH-ERROR-quot-java-cairo-misc-c-380-_cairo_operator_bounded_by_source-quot
  48. Replies
    5
    Views
    139

    Please note: This site is not a "give me the...

    Please note: This site is not a "give me the code" type site.

    If you want to receive help, show us what you have done, and tell us what you have tried.
  49. Replies
    2
    Views
    131

    Kettle is licensed under either a support license...

    Kettle is licensed under either a support license (contact Pentaho for details), or under a liberal license ( http://wiki.pentaho.com/display/EAI/PDI+License+FAQ )

    Whether or not you can use it in...
  50. Replies
    10
    Views
    524

    I'm not 100% sure what you have changed already....

    I'm not 100% sure what you have changed already.

    If you just modified things to enable postgresql, then it should just work out of the box. But in your early posts, you modified userDAO --- so...
Results 1 to 50 of 2751
Page 1 of 56 1 2 3 4