DSXchange

Note that APT_TSORT_STRESS_BLOCKSIZE, if set, overrides any Restrict Memory Usage setting in the Sort stage. ... Ray,Thanks for looking.. "DS_MJ" said he dont have SORT stage in his design but still getting the above said Error.i told him to set the variable and verify whether that works ...

Hello ahmedwaseem2000:

I am doing a Hash partitioning in this join and not using a sort stage.
When I remove this join I dont get this error ("mmap failed: Not enough space")

Thanks again.

Well, I was able to solve this issue. Just for the reference for the people who would be facing this issue in future. It was not the issue with the scratch disk or the swap space. But in the sort I had used "restrict memory usage" which was Causing this error. Anyways, Dsxchange is a plac...

Hello: Datstage ver: 8.0 Database= Oracle 10g Source Table: Months = Numeric Type, Length = 8 Days = Numeric Type Length = 2 The SQL: select COL_AA_DT, COL_BB_DT, Months, Day trunc (months_between(COL_AA_DT,COL_BB_DT )) AS months, (trunc(COL_AA_DT)-trunc(add_months(COL_BB_DT ,trunc(months_between(CO...

1. Set your user variables via the Admin client -> Properties -> Env Variables -> User variables. Let's suppose the variable is called MyVariable. 2. Initialize them in your sequence through job properties -> Parameter. You may assign $PROJDEF as its default value. 3. In the sequence, use a User va...

Hello:

Would appreciate it if you could show me how to set a user defined environmental variable whos value is set to UPPER CASE can be set to lower case as and when required in other jobs sequences.

Thanks in advance.

Mamta

Hello: Would appreciate the following information. DS= Server v7.1.5 QS Plugg-in v7.1.5 OS: Sun Solaris DB: Oracle 9i Topology: DS/QS/ Oracle and RTI on same server. Web Service on another server. Requirement: Get a request real time for an address do data cleansing and standardization of address us...

I am migrating Server jobs to EE jobs and I am noticing that in EE jobs one has to take care of null values or else we get warnings. Example COL NAME = COL_DT TYPE = CHAR LENGTH = 10 NULLABLE = Yes In the server job this is what is done in Transformer COL_DT[1,10] EE Transformer If IsNull(COL_DT) th...

Thanks ArndW and rsripathy, appreciate it. Have a great day.

Server: Substrings(Trim(DSLink49.COL_NM),len(Trim(DSLink49.COL_NM)) -2,3) Is the following code a correct translattion of the above code in PX? PX: Len(trim(DSLink340.COL_NM[-2,3])) In the transformer it does not show red. But when I go to compile the job it doesnt compile. It points to the transfor...

Hi DSguru2B: Thanks I did find Pivot stage in the Plugins. The example showing in there has a difference. In the example it has different Columns that need pivoting. So it has columns Jan, Feb,Mar that are pivoted. However, my job in 1 column (COL_A) it has data seperated by a comma and this seperat...

Hello DSguru2B: I am using DS 7.5.2. In the Help ---under Px Job Stages ---> Processing Stages I dont see the Pivot stage I see all the other stages, nor is it underRestructure stage. When I do a find it just gives the stage its Input and output pages and explanation about it. There is no example. I...

Hi DSguru2B This is the first time I am using a Pivot Stage. I have multiple columns on the source file. A Horizontal Pivot would create columns within a single row into many rows) My Source file looks like this: COL_A | COL_B | COL_C | and so on AC, AG, MA, MM, PH, RE, SR, VO | 1 | ZA0 | ...... MH,...

DSguru2B wrote:Use the CONVERT() function and convert all commas with char(010) (new line character on unix).
This will be sufficient if there is only one column in your source. If you have multiple columns, then you can use the pivot stage.

Thanks DSguru2B for the quick response. I will go ahead and try it.

Hello:

How to add a line for each value in the Column?

Example:
Column value in COL_A is CH, SE, SR, etc,

So for COL_A , there will be 3 rows.