DSXchange

Hi,

Anyone, Please let me know the hardware and software components required for using teradata database stage for both server and parallel jobs.

I am trying find out information about installing teradata utilities foundation on all nodes for parallel jobs. If any one has links or docs, let me know.

I am trying to retrieve decimal fields using user defined sql thorugh oracle enterprise stage. I am trying to replace decimal field null values to '0'. The query working fine without NVl Function but it's not working with NVL. Let me know the possible solutions. We have to do it through oracle query...

Do you want records which don't have a match in the join in the rejected records? If so, you can use a left outer join(by properly ordering the links) and in a downstream transformer you can check if a not nullable column(you should pass a not nullable column to the output from the right link in th...

Additional Info:

When I try to execute c++ code..It's giving the following error

0509-036 Cannot load program because of the following error

0509-108 The .loader section does not exist.

Is that the problem?

can we execute the c++ code on AIX5?

Even if I use user defined variable, I am giving the total path with object file name for linking object code to datastage. Where do you want me to use the user defined varaible?

I do have $LIB_PATH only. So I changed the path to this environmental variable defalut value.

I can't find $LD_LIBRARY_PATH variable. Looks like it doesn't exist here.

I tried that already and still not working.

piyu wrote:Done it!

Used the "MAkefile" script which come with the installation cd to create shared object.

The option it uses on AIX are: -G -qmkshrobj=1000

Can you please explain clearly?

Where can I find sample code(built in) for parallel routines?

Tried after adding the new parameter LD_library_Path but same error.

I don't have access to create or put files in to LD_library_Path. So I kept those files( cpp code and generated object file) under the Datastage/PXEngine.

Is that the problem?

Tried after adding the new parameter LD_library_Path but same error.

I don't have access to create or put files in to LD_library_Path. So I tried to put those files under Datastage/PXEngine.

Is that the problem?

#include <string> #include <stdlib.h> #include <stdio.h> using namespace std; //================================ int PMExists(string& elem) { size_t startpos = elem.find_first_not_of(" \t\n"); size_t endpos = elem.find_last_not_of(" \t\n"); int ans =0; if((string::npos != sta...

#include <string> #include <stdlib.h> #include <stdio.h> using namespace std; //================================ int PMExists(string& elem) { size_t startpos = elem.find_first_not_of(" \t\n"); size_t endpos = elem.find_last_not_of(" \t\n"); int ans =0; if((string::npos != sta...

I am getting the following error when i used parallel routine in a transformer.I wrote c++ code and i compiled and produced *.o file and i used that file in the library path of the parallel routine dialogbox. I got following fatal error when i ran the job and then it aborted. Transformer_3: Failed t...

Guys, I have 5 columns in the source, out of that 2 columns are keys. I have three non-key columns, out of that 2 columns are "from_date" (col4)and "to_date"(col5) goa is to remove duplicated based on key values but some duplicates are valid based on from_date and to_date. Let's ...