DSXchange

Sorry Srini,
I did not understand the below line given by you.

You need to use read it as a string and map the appropriate DTD using the XMLMetatdata Mapper .

Srini,
the given link have the list of xml stage's data types and its corresponding data types in data stage.

i have oracle table as a source and its column data type is xmltype.
In the given likn's list there is no data type like xmltype.

Srini,
I have tried with Longvarchar or longnvarchar, its not working.
Same error i am facing.

My source oracle table is having a single column A. its data type is xml and having a single row in it. i want to view its data from data stage. i tried with oracle enterprise stage but no use. In data stage we dont have the data type xml while reading from table, so i gave it as unknown. the below ...

While using the @INROWNUM in Transformer this problem may occur because of the partitioning. Try to change the partition.

Hi,
My unix script need to return a value to Exceute command stage.
I have used Return value from activity variable but i am not able to handle it.

In that case we are losing the power of partitioning, Right?

i just want to know is it possible or not, by using the partition settings.
Except Entire.
If not possible, please confirm the same.

Yes,
we can achieve it by setting to sequential or running in single node.

My job is two node configuration.

can you please let me know is it possible with any partition settings?


I feel we can,but do not know how. by using Entire partition i am able to get but data is repeating twice.

I am not getting the target data in sort manner. I have tried with all types of paritions but no use. Scenario is very simple as follows. ROW GENERATOR ----->SORT STAGE------->Data Set. source has only one column data type is integer. Source: Row Generator COLUMN1 0 1 2 3 4 5 6 7 8 9 Target 1 2 3 4 ...

Thanks it is working :D

aravind will you please let me know that where can i get the metadata work bench.

where can i get this?

Hi, I know only my target table name map_mat_plant. I want to know the job(s), which are loading this table. I have tried the advanced search option in data stage 8x. The option "Name to find" is giving no output. the "text in the object description is giving large no of output. which...

Hi Priyadarshan, Please see below explanasion on two queries asked by you. 1) I have checked the job parameters in designer and Environment varibles in the Data stage Administrator, it is confirmed that the we have not used APT_NO_PART_INSERTION variable. Now the job is in production. 2) There are n...