DSXchange

As can be seen from the file, the first column gives the number of values to be added. Call a routine. A for loop which counts for the number of times of this first column value should work. If we want to do this in a Transformer, as Craig suggested if we know the maximum value in the first column, ...

Is it possible to increase the maximum number of base or paired records more than 100 to be shown in the reports anyway? If we give a number above 100, it does not accept it. As per the cross domain analysis between two tables, there are some 269 data values which are present in the base column and ...

I am trying to do a key and cross domain analysis between two tables. In the available pair section, for the base table, not all its columns are appearing under the Compatible column list. Does this mean that there is no corresponding compatible column in the paired table(but in fact there is a corr...

Thanks Vmcburney. Got your point. Over to Divine now

Not to barge in this thread, but as my query is exactly similar want to know this. Is is possible in Information Analyzer to apply rule to data, for eg : If value = 'C' convert it to 'CAD' and then run the 5 analysis? Or the rules are only used to view specific kind of data as we want to have it.

Hi Ray,

Which stage would suit here then... I used change capture as I wanted to compare one file with respect to other on a key and change value column.

Is there a better option?

Hi, When we use a change capture stage on a before and after dataset, we get the 'keys' and 'change value' of only the AFTER DATASET in the output. Is there a way to get the change value of the before dataset as well. for eg before dataset col1, col2, key a b 1 a c 2 after dataset col1,col2,key d b ...

Hi James, I tried to use the external target stage for the first time. It says 'It allows you to write data to one or more source programs', but my requirement is to insert repeating headers, so not sure how it is fulfilling that. Also I could not find how to insert multiple headers in a flat file. ...

Hi, I know that DS is not a reporting tool, but we donot need to do any fancy formatting, just insert repeating headers after certain records in a file. One way I can think of is call a after sub-routine and call a unix shell script to insert the required details after every say 50 records. Is there...

I have checked the key value and it is unique. So I tried this :- Go to oracle stage properties then Stage -> Advanced and click on the selection button of node map constraint then select a node to run that stage on one node as suggested by priyadarshi and it worked.Job completed successfully :). Th...

Hi Priyadarshi

Thanks for your suggestions.
In the advanced tab I can't see any option to define node. All I can see is buffering options. I am using DS 7.5.1 enterprise edition.

I am not a premier member :( ...So can't read all of your comment..But I tried running it with single node by changing the .apt file..and it worked... I want to understand how only that job will be configured to run on single node..cause when I change the .apt file it is appliclable for the whole pr...

yes..the table is waiting for locks to be released..but these locks are created due to paralle processing..So the four parallel processing are in a dead lock state I believe..hence no rows are getting updated even if the job is running for days...the table contains more than 50m records...Now I want...

I have already posted how the update statement looks like...I can't post the exact update statement...

Sorry..there are no duplicate in the key values...