DSXchange

Hi Did you find any solution for this issue? I am facing exactly same error message during the installation.

Hi , I am trying to install Metadata repository on the same machine where engine and domain will be installed. Version is 8.7 on Windows. In earlier version repository was on Oracle server outside this machine . What should be my initial steps to setup metadata repository on the same machine ? Any h...

qq

Ray , I couldnt see your complete mesage . My Datastage is on Windows platform . How can I decrypt this file . I used FTP stage to get the file into datastage and loaded into some temporary file and i want to Unzip or Decrypt this file . How can i do either of them . Please suggest

They use AES algoritham to do so ! how and what we need to do in datastage to decrypt this

qq

hi

Thank you so much for the response Andrw ... Thing is i have date datatype field coming in so its Date- 18-Aug-2012 . So i used to converstion DatetoString(mydate,"%mm/%dd/%yyyy) then i coverted it back to Date filed so i used StringtoDate(abovecode,"%mm/%dd/%yyyy) .. Ideally this should g...

Hello everyone .. I have an issue with Date format - My input is Date datatype "18-Aug-2012" and my ouput should be "08/18/2012" wite date datatype . So i used StringToDate(Datetostring(date,"%mm/%dd/%yyyy),"%mm/%dd/%yyyy) ) .. The first convertion gave me output as 08/...

I Tried same once with following approach , My gola was to get the count of rows during tht particular run and get this count value in one of the column . So i did as follow , 1.From Transformer defined a variable COUNTER with values as '1' 2.Aggregate grouping on this COUNTER and using Count functi...

Hi All, I need your help on below question , How can i pass a changing value as a parameter in the job . For example i have Source filename - FName.26.06.2012 and tomarrow it will change to Fname-27.06.2012. How can i call these daily source files with name change in my DS job ? I would really appre...