DSXchange

Sort -u, It only sorts the values.
But it didn't eliminate the duplicate values.

Its not the right one.
before posting, Please check and post.

Hi, My Source file is an Sequential file, Where i have duplicate values in my Sequential file. I have select only unique records from my source. I dont wanted to use any other stage's to filter the duplicates, Because we have Filter option in Sequential file. By using the filter option can i do it ?...

Hi,

can any one tell how to define output columns in the compare stage, by default it wont define any columns, There must be an three columns
Result
First
Second

How to define first and Second Column names.

regards
magesh

Hi,

I am getting this msg when ever try to connect oracle, Please clarify.

ds_loadlibrary: Win32 error in LoadLibrary of oraoci8.dll - The specified module could not be found.

Regards
N.Magesh

Hi All,

can anyone please explain the difference between Multiple instances and parameterize the values in the job. whether both will perform the same action????

I dont think this is the correct one... create one simple job and add a transformer stage on. Go to Transfomer properties-->Click on derivation of a clumn on output link. You will see list of available transformation like DS Macro,DS Rotuine ... You can also create your own routine. For more informa...

ray.wurlod wrote:In what stage type? ...

Oracle Stage...

Hi all,

What are different types of transformations available in Datastage..

Thanks
N.Magesh

Hi All,

Please clarify what is the difference between Transaction type and Array list.

Hi all,

What is the protocol used in Datastage client server Architecture??
Is it TCP/IP or something else.... Please clarify

Thanks
N.Magesh

Hi,
In my ODBC Stage i have selected user defined queries, I want to write a two queries in Enter SQL box. How do i separate two quries, Whether its possible???

First i have to delete records from the table and i have to insert into the same table, Please clearify...

Hi,

I have two links from Sybase stage,i want to know that which one will execute first.

Whether i can control my execution order.

Ya its a 7.5x2 windows version, I think i have to install the sybase client in my datastage server, correct me if my understanding is wrong because when i run the job its shows Dll can't be loaded. shows could not load dsstpora.dll If you are talking about the above dll. Then, I believe it( ds stp ...

Which 'X'? Are you running 7.5x2 the version which allows PX jobs to run on Windows? If that's the case, you are out of luck until 8.0 is released from what I understand. ... Ya its a 7.5x2 windows version, I think i have to install the sybase client in my datastage server, correct me if my underst...