DSXchange

Try to put a sorter upstream the joiner,instead of tsort and try assess the change.Also,ensure that its hash partitioned and try interchanging the streams of join(left to right).

SAMEENA wrote:Hi Salil,
I am able to insert timestamp with microseconds from backend.

What if u use the same(from backend)timestamp formatting in the user defined insert statemnt inside ur DB2 stage??

Do u have the table already created in Teradata??

Try a manual insert into the Database from backend to check whether ur DB settings allows the data in the exact timestamp format.

Can u tell us the average size of ur single record when it reaches the aggregator?
Any idea about the system memory?
Are the inputs partitioned in each stage?
How many nodes specified in parameter file?

Try running in a single-node configuration - does it work? If yes, you might be running out of resources. Thx a lot Arnd, I was not using any lookups inside the job. It was resource scarcity.I just checked the configuration file and it clearly mentioned it,one of the sectionleader is died.I cleaned...

One of my jobs which used to run fine previously is getting aborted.I tried running and monitoring it several times and found that the Abort happens immediately after it reaches the 10:00 min elapsed time threshold. The number of rows processed during this period varies in b/w 80000 to 100000 for mu...

Hi, Please give me solution for the following error: Sequential_File_8: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. regards, MCH I guess the probability is that your RCP is on for the previous stage which already has a par...

Are you able to enter path values in DS Administrator?
Check in Environment for your particular project and ensure the values are correct.

node_node1: Unrecognized module name "orautils" in environment variable APT_DEBUG_MODULE_NAMES [ifdebug/ifdebug.C:65] This is a warning message I'm getting before my job aborts with fatal message : TARGET_TAB: connect failed for env: devsid, user: devusr, password: ***** Oracle error: -212...

amit_dwh wrote:Hi

How could a product join be inmplemented in Datastage Px as join stage supports only left , right , inner and full outer joins.

Thanks

Try to do the inner join based on Key columns as some dummy Value.

IHTH

I have dates in the following format coming in as source data: YYYYDDD. Where ddd= the day of the year. When I output these dates to our warehouse I know I will have to convert them, but I also have values of 0 in these fields which I would like to convert to null. Is there anyway to do this in PX ...

main_program: Error loading "orchoracle": Could not load "orchoracle": ld.so.1: osh: fatal: libclntsh.so: open failed: No such file or directory. Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are pre...

Hi,
The Oracle client Version is 9.0.1 and Oracle Server Version is 9.2.0.7(64 bit).Could it be a probable reason?

ray.wurlod wrote:Check that your Oracle client software is at the same version as your Oracle server.
What stage type are you using in your DataStage job?

I'm using Oracle Enterprise stage for the Oracle connection in the Datastage job.