DSXchange

Now the Warnings are different than above..Please see the below warning after sorting the input and and the same sort key is used in the group field in the aggregator with Method = Sort. Any inputs greatly appreciated. Aggregator_33: When checking operator: User inserted sort "Sort_22" doe...

Hi All,

Datastage server time is EST and in the jobs we want to insert GMT times..
so how do we do the conversion , taking care of the day light savings ?

Any thoughts greatly appreciated.

Thank you all.

Thanks Pravin for your response.
The group field and sort key are the same and that is only one field.So not sure reason for warning.

Any inputs greatly appreciated.

Hi All , Even after sorting and partitioning the data on key field (group field) Method = Sort in aggregator stage is causing below warnings..and the input file big. Not sure what I am missing? Aggregator_33: When checking operator: User inserted sort "Sort_22" does not fulfill the sort re...

Hi All ,

I am getting the following type warnings for the aggregator stage ..

Aggregator_33,3: Hash table has grown to 16384 entries.

what does that mean?

Any inputs greatly appreciated.

Thank you.

Ok , Dump Score can be checked from the director log?? Is that right Ray ?
As all the information is under main_program..

Thanks for your response Ray.

Hi All, In the Aggregator stage there are properties under the Input page and partitioning tab like choosing the partion type , key field, sort type , stable and unique and on the Stage page and propertied tab..there is an option to Method = sort/hash .. what does this mean?? How does properties on ...

Hi All, In the Sort stage there are options under stage and properties tab to choose type of sorting (asc/desc) , sort key , stable sort .. , and on input tab there are options for partitioning , stable , and to select key field , choosing sort order (asc/desc) ,case sensitivity and unique, How are ...

Hi All, When aggregator or Join or Sort .. are used.. hash partitioning..is used..as it is key partitioning method.. If "Auto" partioning is selected will the results be still correct and what partitioning would be inserted?? Manual says Auto would pick the right partitioning method as nee...

Hi All,

Once I have $APT_DUMP_SCORE as parameter , the score can be cheked under the mainprogram in the director log , is that right?

Thank you all in advance.

Hi all , I am trying to use wrapped stage for invocation of any unix commands or shell scripts.. ,So I am trying the example and mentioned in the manual .. and I am getting following errors when I run the Wrapped job.. main_program: Processing export schema for input 0: "quote" value must ...

It will, because it needs direct access to the server engine. Thanks Ray for your quick response. 1. So the Basic transformer stage runs on the headnode? Can you please confirm..? 2. So any parallel routine call from parallel transformer stage would run on the compute node? Can please confirm this ...

Hi All,, We are building jobs in Grid env.. in order to avoid the load on the headnode.. we are trying to call a routine from basic tranformer stage rather than routine activity stage (for a server routine) in a sequencer.. , so just want to understand if the basic transformer stage would be run on ...

Hi All, I am getting the following error in a sequence job..which is Grid enabled. main_program: Internal Error: (!new_sc_op.availableNodes_.isEmpty()): sc/sc.C: 4304 Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH Could someone please give some inp...

Hi All ,

Getting following error message..

Sequential_File_0,0: Field "TRANSACTION_AMOUNT" has import error and no default value; data: {0 0 0 0 4 4 3 0 4 7 5 8 2 9 9}, at offset: 76

what does that mean?

Any thoughts .. thanks in advance.