DSXchange

Hi Gurus, I am getting the following error when i am looking up data from a oracle table. Output from transformer compilation follows: ##I TFCN 000001 05:50:42(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Right...

Any help would realyy be appreicated.

Never seen this issue in v8.

Hi Gurus, I am reading multiple files using the file pattern property in a sequential file stage. I am fetching the filenames using the File Name column property. I am also setting the Environment variable $APT_IMPORT_PATTERN_USES_FILESET=TRUE. I am able to fetch the filenames for each record read. ...

Aqulis,

So your job is loading Data fine with DRS stage and not with Oracle stage, Is that correct?

Try keeping the target datatype as unbounded varchar and try with Unicode set and unset as well.

Also is the target written in LOAD mode or Upsert?

Chulet, It's only for Oracle Enetrprise stage since enetrprise stage don't have any Transaction level settings, either it will take 5000 or 5 Sec as the default Commit interval for commit. Then what about 'DRS Stage',which has got Transaction level & array size settings as well. If we are using ...

Just to add...

When the Child records are missing in the XML file....The associated tags are also missing. But whereas my xsd will have these tags defined.

Hello, I have a XML file as one of the source to my job. I am validating the XML against a xsd file. In the xml file i have child-subchild on so on upto 4 levels. Any given day I may or may not receive all the subchilds. Even the tags for these sub-childs will not be present in the xml file. In that...

Hi All, Please let me know what is this error? "node_node2: broadcastStepIR: score file write for 4096 bytes to file /tmp/APTps901232091bcdf0 on node node2 returned -1; errno = 28 (file system full) Consider setting TMPDIR or APT_PM_SCORE_DIR to a directory with more space. " main_program...

There are various ways of removing the ^M characters. Simplest one is to use the dos2unix utility. This will work...Just in case if it doesnt, use the tr utility of unix. Use the following command to remove the ^M characters. You can use this commands in a before job routine and strip the unwanted c...

The variable $APT_IMPORT_PATTERN_USES_FILESET_MOUNTED is not supported in version I am using. I tried a workaound and its working. In the sequential file stage, I used Read Method = Specific Files and used 15 different File properties. Each property specifiying name of one of 15 files. Also the opt...

Please re-check. The row limit tab is present for PX jobs also.

What is your source? what is the type of partitioning you are doing in the job?

What is the OS flavaour?

Please give us more information about the queries. Are you trying to create a Cross-Product looking at the queries that you posted that will surely fetch a lot of data, Since it will be a cartesian product. Give us clear requirements than we can help you.

Without the 4 MOD() functions the CPU utilization is still close to 90% for the entire time the job runs. Andrw, when I monitor the statistics for transformer, The %CPU usage is very high (168). I think the transformer is too loaded so I added another transformer which carried few data validations. ...

Andrw, As you suspected the the cpu utilization is more than 90% most of the time. I am pasting the scrren shot of vmstat procs memory page disk faults cpu r b w swap free re mf pi po fr de sr s0 s1 s1 s3 in sy cs us sy id 1 0 0 49556856 3932552 205 857 543 116 117 0 1 0 18 18 0 5660 7855 2598 25 14...