DSXchange

Hi ,

Am converting a string to date using the below transformer function (StringToDate(Lnk_Transaction_Read.ORDR_VLE_DT,"%yyyy%mm%dd"),
However the output is the following format "YYYY-MM-DD" how do i remove the "-" ,thanks in advance .


Sam

WoMaWil wrote:Hi Samuel,

is it only something optical or are metadata definitions not feasible?

I've tried and it works for me.

Wolfgang

Hi ,
i did not know how to do it,Arnd was kind enough to tell me how to do it.

Thanks for your Concern
Samuel.

Since you can define a single hashed file stage (by this I mean the graphical object in the designer) to have multiple output links with multiple hashed files, each of the output link attributes needs to be defined; so if you have 2 links to the same file you will need to click on the drop-down lis...

You can have multiple output streams from a hashed file stage as well as multiple reference streams AND even several input streams, too. Just draw a link in the appropriate direction to/from the hashed file stage. Hi Arnd, i tried that ,but that box on the link which appears when the definitions ar...

Hi Samuel, I really don't thing its possible to get mutiple output links from the HASH file, i.e., Can Get One Stream Output and the others reference outputs Only. But if your planning to do it that way, u can have mutiple output links from the same hash file stage on to a Link Collector and then u...

hi ,i need the output link or copy from the hash file to different transformers Db2stage------->Hash --------->transformer1 -------> transformer2 Now i need the copy of the link from the hash to be connected to transformer 2 or the same column defintions,there is only one output tab in the hash file...

ray.wurlod wrote:Beware, though, that you will flood this system sooner than one with multiple CPUs.

Thanks Guys, so i will start fiddling around with Px, The organization where I work has ordered a Dual Cpu Machine,but that will take time .

Hi ,
Is it possible to run datastage px on a single processor system ,i remember reading somewhere that it can be done with changes to the configuration file.I havnt used Px till now so if it is possible please provide the details. :D

Thanks
Sam.

[quote="ray.wurlod"]QualityStage is the perfect tool for the specification you have given. It is callable from DataStage or works stand-alone, and can perform freeform probabilistic matching.[/quot


Thank You Ray and ArndW for helping me out.

[quote="ray.wurlod"]QualityStage is the perfect tool for the specification you have given. It is callable from DataStage or works stand-alone, and can perform freeform probabilistic matching.[/quot


Thank You Ray and Arnld for helping me out.

ray.wurlod wrote:Why not create a server job to create the text file, and a job sequence (or job control routine) to run that job then email the file?

Thanks for the help guys.

With Regards,
Sam.

Hope you can achieve this by writing a routine and the routine can be called by routine activity in the Job sequence. Read the log from the repository and write the log info into a text file and this can be achieved by using OpenSeq/WriteSeq functions. HTWH. Regards Saravanan Hi saravanan, the comm...

Hi all , The child sequences contain individual jobs. In all child sequences there are "e-mail notification activity" stages to know the final activity of the job. For now those are designed to tell just the "Job status", which is not sufficient. So I was asked to come up with a ...

hi ,
if u folks out there have some documents on datastage best practices,performance,please forward it to me,i need the documents to create a presentation for our client and i have to complete it quickly.My mail id is samuel.rajesh@gmail.com.

With Regards
Samuel.