Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Replies
    4
    Views
    1,140

    Hi You can write a Wrapper Script making them...

    Hi

    You can write a Wrapper Script making them all run in parallel

    and using wait and catching the error codes you can make your wrapper Job SU or FA

    Thanks
  2. Replies
    1
    Views
    998

    Please check the TF Under PDI/Samples :-...

    Please check the TF Under PDI/Samples :- JavaScript - create new rows.ktr
  3. Replies
    4
    Views
    2,625

    Thanks this works !!!!

    Thanks this works !!!!
  4. Replies
    4
    Views
    2,625

    Hi .. I am sorry if I was not clear.. I am...

    Hi .. I am sorry if I was not clear..

    I am kind of novice to Java scripting and language ...

    can you please let me know the function which does this conversion from decimal/string to...
  5. Replies
    4
    Views
    2,625

    Please help - Decimal value to hexadecimal ??

    hello !!

    i need to convert Decimal value to hexadecimal... If anyone tried this Could you please let me know How I can do this

    Thanks
  6. Replies
    1
    Views
    986

    filter a column based on pattern

    hello

    I tried to seacrh but couldnt find anything regarding the string filter

    I am trying to filter out a column based on a pattern. That is if the value exits in the pattern it should write...
  7. Replies
    2
    Views
    1,368

    I am not sure if i am correct in my below code...

    I am not sure if i am correct in my below code ..... But I am not getting the expected results




    var temp="0";

    for (var i=0;i<getInputRowMeta().size();i++) { //loop through the actual row
    ...
  8. Replies
    4
    Views
    2,099

    Thanks a lot guys !! matt ur thing worked in...

    Thanks a lot guys !!

    matt ur thing worked in btween
  9. Replies
    2
    Views
    1,368

    rollup/aggregate fn in PDI

    Hi,....

    I am kind of replicating the aggregate/rollup functionality in pentaho

    For the i/p data ....

    Need to assign a temp var and for every row . Based on some column cdns

    example: if...
  10. Replies
    4
    Views
    2,099

    date diff for NNN formats

    Hi,

    I need help in fining the difference between two dates of the format YYYYMMDD HH24:MI:SS.NNN

    example (20090505 13:30:00:990 - 20090505 13:30:00:668 )

    Anyone tried this ..

    Thanks...
  11. Exporting an xml file other than shared.xml at runtime

    Hello,

    I tried but couldnt figure this out!!

    Did anyone tried to export an xml file other than Shared.xml file at the Job runtime.(The xml file contains shared steps and functions info ..)
    ...
  12. Replies
    0
    Views
    755

    working for common

    Hi,

    Is there a way , to import Common DML (at a specified location) into CSV input or Text file input.

    Example:

    Namd type format position
    empname string
    empid integer ...
  13. Replies
    1
    Views
    1,191

    executing shell scripts within Ktrs

    hey ,


    Can i execute Shell scripts with in ktrs. I know that Job has a step which does that for me.
    But with in a ktr , How to execute shell script ?:confused:
  14. Output table step - use batch update for Inserts

    Hello,

    I am trying to load data using output table step.

    I have around 2.5 mil records. And

    Target table: TRUNCATE and load
    Indexes: indexes all are non unique

    1) When i try to load...
  15. Thread: Delimiter Ç

    by casper
    Replies
    5
    Views
    3,866

    Hi... I have set the encoding to use...

    Hi...

    I have set the encoding to use ISO-8859-15 and delimiter as Ç

    Even then its not getting recognized in unix box

    Any thoughts !!!
  16. Thread: Delimiter Ç

    by casper
    Replies
    5
    Views
    3,866

    This works on desktop but on unix box It doesnt...

    This works on desktop but on unix box It doesnt recognize ....
    In between I have LANG=en_US.UTF-8 on the box
    Any thoughts
  17. Thread: Delimiter Ç

    by casper
    Replies
    5
    Views
    3,866

    Delimiter Ç

    Hello ,

    I need to read a file with Ç delimiter on unix box
    How should i specify delimiter tab in CSV input step in pentaho

    Thanks
  18. Replies
    2
    Views
    1,528

    Ahhh yes i couldnt figure that out.. Anyways...

    Ahhh yes i couldnt figure that out.. Anyways Thanks for the reply
  19. Replies
    1
    Views
    877

    question reg copies

    hello,

    I am trying to figure out whether "Number of copies" option could be helpful to me for situations below

    -- where I need to merge huge files and then sort them on a key ..
    ...
  20. Replies
    2
    Views
    1,528

    File Watcher functionality

    hello

    i tried to search but couldn't get this kind of functionality

    Just was wondering if we have any step which basically waits for a file to land ... Then based on Success or failure Cnd's it...
  21. Suneel for your question in specific the...

    Suneel for your question in specific the equivalent to Expression would be a Java script transformation , thats what i have noticed till now ...

    But for ur example as replied by fabian , you can...
  22. Replies
    2
    Views
    3,200

    Thanks fabian.. So ideally the input value...

    Thanks fabian..

    So ideally the input value should be equal to output value in an input/ouput metrics step , for an ideal step behavior.. Am i ryt??

    And how do I get the input/output metrics if...
  23. Replies
    2
    Views
    3,200

    Step metrics: Basic question

    hello,

    I searched a lot to find out each metric in Step metrics tab (After i Run a job in spoon ) and what message does it convey.

    Could anyone of you tell me about the input/output metric .. ...
  24. Replies
    6
    Views
    1,789

    Matt and other who are supporting this forum .......

    Matt and other who are supporting this forum ....

    Thanks and appreciate ur timely responses...

    but I didnt get my any suggestions for the second point that I have asked..

    would appreciate if...
  25. Replies
    6
    Views
    1,789

    Thanks a lot for ur replies.. 1) In the...

    Thanks a lot for ur replies..

    1)
    In the transformation settings, I see "Nr. Of rows in rowset " for Miscellaeous tab. if i increase this number from 10000 to 100000/1000000.. Does this increase...
  26. Replies
    6
    Views
    1,789

    Unloading large tables

    Hello,

    I am trying to unload a 50 Mil table.

    And i have divided this query in 5 small queries (partitioned on Code) ..

    I am calling all these 5 different queries in 5 input tables and...
  27. Replies
    3
    Views
    1,201

    Change number of Copies - Clarification

    Hello

    I am trying to unload 1 mil records from a query which joins 3 huge tables.

    And I did couple of tests with change number of copies option :).. I need some clarification on the Change...
  28. Replies
    1
    Views
    959

    Merging huge data together

    hello,

    I have this req.

    I have 6 to 7 files of containing same columns, And has the data around 7 to 8 Mil records in each file.
    The data is sorted with in the files on the key column (ID).
    ...
  29. Performance btween Stream lookup and Merge join..

    Hello,

    I have a huge file around 10 Mil data in a CSV file .. Which has to be joined against the main stream data to get some fields.

    I have two options as

    1) Going for stream lookup -...
  30. Thread: Denomalization

    by casper
    Replies
    1
    Views
    1,122

    Denomalization

    Hello,

    I am working on Normalizing a huge data or around 10 million data using the step denormalizer.

    below are the input and ouput..


    ACCOUNT_ID NAME (String) VALUE (String)...
  31. Thread: look up

    by casper
    Replies
    1
    Views
    974

    look up

    Hi,

    I am trying to look up a database table based on some string coming from the previous step.

    I need to get the results as per the following query in SQL:
    SELECT COLUMN_NAME from TABLE where...
  32. Replies
    10
    Views
    1,779

    Thanks a lot :) .. I was just checking the...

    Thanks a lot :) .. I was just checking the message ...

    Let me try it out to my req.
  33. Replies
    10
    Views
    1,779

    Thanks a lot for the replies, Ahhh .. This...

    Thanks a lot for the replies,

    Ahhh .. This settings gives me the loggin information at transformation level. But if i need to capture in between steps . How can i do that ?

    File--> JS script...
  34. Replies
    10
    Views
    1,779

    Thanks for the reply. Can u pl explain in...

    Thanks for the reply.

    Can u pl explain in detail as where I can set the settings
    to log into DB for Each individual step

    Casper
  35. Replies
    10
    Views
    1,779

    I have idea about the logging information taken...

    I have idea about the logging information taken from DB ,

    But my requirement is bit different and i am reading on this :-)

    I have to get the no. of records records read from the previous...
  36. Replies
    10
    Views
    1,779

    getting the records loaded between steps

    Hi,

    I am working on a transformation and the requirement needs that I need to capture records read and written from each individual step.

    how can i do this ? is there any step or process in...
  37. Replies
    1
    Views
    914

    Hi, You can do that in a java script by...

    Hi,

    You can do that in a java script by calling the date2str functions.

    Pl check the date2str_sample in java script transforms. that would help u understand better

    Casper
  38. Thread: java script

    by casper
    Replies
    1
    Views
    1,214

    java script

    Hi,

    I was working on Java script, for one of the req ,Just wanted to know more about the J.S step

    a) Set Start Script
    b) Set End Script
    c) And Set transform Script.

    q1) When do u use each...
  39. Thread: var Scope type

    by casper
    Replies
    1
    Views
    2,297

    var Scope type

    Hi,

    I was workin on SET ENV var STEP.

    Could you please explain the Variable Scope type in the same step which has the values as
    a)Valid in the Java Virtual Machine
    b) valid in the Root Job...
  40. Replies
    1
    Views
    978

    How can we perform Control Checks ?

    Hi,

    I have a requirement as capturing the Balance and control. For an ETL process

    a) Like I need to capture the no of records in Input file and no of records got loaded in a table. How can i...
Results 1 to 40 of 40
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.