DSXchange

veera24 wrote:2. why don't open the stages and verfiy it?

I opened stages and i didn't find any option to preserve sort order in the output of these stages.

So, only i wanted to know if it is default for these stages to give sorted data on each partition as provided in the input link per partition.

Next time you're in that screen read the help on entering ASCII codes for non-printing characters. I read the ascii help on this. And i tried using the delimiter string option in format tab of sequential file. I tried using char(25) , 'char(25)' But i dont see Ctrl-Y in the output of my file. Pleas...

I have 3 questions: Question 1: I have a transformer for which i am doing link sort and hash partitioning to perform some logic The keys are: Product (partitioned & Sorted) minqty (sorted) maxqty (sorted) mincost (sorted) maxcost (sorted) Now the output of this goes to 2 streams one with remove ...

Would appreciate reply to my remaining questions please

I have couple of questions on Integer to Decimal and decimal to integer. I know decimal (5,2) represents 3 digits before decimal point and 2 digtits after the decimal point. so total is 5. In case of Integer(5) it seems to hold more than 5 digits. I would like to understand the concept of small int,...

ray.wurlod wrote:Why do you believe that the Sequential File stage does not allow using Ctrl-Y as the field delimiter? How have you tried to enter that value into the Field Delimiter property?

Yes i tried.

For Ctrl-Y i have to type in char(25)

And the delimiter allows only one character there.

Please help.

Hi, We usually use Pipe seperated sequential file. In this case we have source data containing both pipe and comma. i tried different options available as delimiter in sequential file but nothing seems to work. I have implemented earlier Ctrl-Y char(25) as delimiting characters in my transformer ear...

Another way to do this would be to pass a parameter with a schema file that defines the key for the particular table you are updating or deleting. In your update and delete job you will expose some generic column(s) as the key columns using the column export operator. This key could then be used in...

ray.wurlod wrote:You can perform the same hacks that they performed.

Glad i was able to get the benchmark values from XMETA to the view, so that the DataStage can read it.

I can only answer your final question. That answer is No. (That probably addresses the other questions as well.) We got this view intially created by a contracting company. How did they get to join the tables in the view. And view seems to work fine. There should be some way for us to add an addtio...

Hi, I have an existing customized view and would like to enhance it by adding the field "BENCHMARK" value for the rule . I am have searched the xmeta for the table with names 'BENCH' i got 3 tables: INVESTIGATE_XMETAGEN_BENCHMARKCATEGORYEC1481DF INVESTIGATE_XMETAGEN_BENCHMARKMASTEREC1481DF...

Appreciate help on this please.

Hi,

I am trying to find a place to renew my membership on this website but could not find one.

Also looking for any coupons and promotion code.

Help is appreciated.

Thanks,

The state file can not generate random values. What are you actually seeing? Is the remainder of the job running in sequential mode? Sorry for the delayed response. The portion of job before surrogate key generator is in parallel mode. And then the surrogate key generator in sequential mode. And th...

EDIT: I updated the target table to value 85 for the surrogate key column. And ran the update surrogate key job. Now i see 4 values in state file. Surrogate_Key_Generator_0,0: Content of state file /etl/process/dev/cfg/skey_product.ctl: 2 2 86 86 Also noticed that the state file is generating random...