DSXchange

Here goes my five cents: I think the logic for partitioning data in a stage (or link to be more precise) is required when you have to match data between links (join/merge/lookup etc) or to compare rows within a stage (aggregator, R-Dup etc). This will help improve accuracy and performace, as you ca...

Hi, is there a thumb rule for what stages you need to partition/sort data for proper functioning and for what you dont have to. To my understanding, some stages like join,merge,aggregator,remove dup etc need the data to be partitioned and sorted for them to produce expected results. Just leaving aut...

Hi i am trying to build a parallel routine to calculate md5 check sum for any string. i took the standard md5 code implemented in the rfc 1321. i could get it working with a build op,but when called as a routine, i get some non-printable/junk characters in the output.// i guess it has something to d...

No Inputs ?????

Hi i would like to hear from experts here on what exactly is a cofigurable ETL engine or Dynamic schema driven etl engine and how does Datastage fit into it. Can you please explain the actual need for a configurable ETL solution and the basic necessity that drives these ideas and any insights on pra...

Hi

i am looking for some documentation on the usage of SAP Pack. i dont have the sap adapter and hence i dont have any pdf/manuals related to it. please share any of such documents.

Hi i have seen in some of Vincent's blogs that V8 is available for download. i have a IBM id and a partner world id. Still i am not able to download the software. i am lost in the site. There is one particular link that takes me to a page where it asks for Site Number. i don't understand what is thi...

Hi, I have a input data Varchar(24) coming as 214584654200708086120001. I need the output as Integer(24). I tried using AsInteger function. But, the output is giving me a completely different number. Please provide a solution for this.... forget about datastage, integer can only have 2147483647 as ...

Hi, How to pad zero's to the left of an integer? I have 2 inputs Id1(Integer 21) and Id2(Integer 4) I want the output as Id3(Integer 25) Logic for Id3 : Concat Id1 and Id2 If Id2 = 24, my output should be Id1:0024 If Id2 = 235, my output should be Id1:0235 Please provide a approach for this. Try St...

Hi, How to pad zero's to the left of an integer? I have 2 inputs Id1(Integer 21) and Id2(Integer 4) I want the output as Id3(Integer 25) Logic for Id3 : Concat Id1 and Id2 If Id2 = 24, my output should be Id1:0024 If Id2 = 235, my output should be Id1:0235 Please provide a approach for this. Try St...

Hi, i would like to trap the condition "No record passing through a stage' The scenario is that for a specific condition, no records come into a transformer nor go out. in that case, i want to write something to a file from one of the transformer links saying that output is 0. i tried @INROWNUM...

Hi

i need to read a .mdb file and a .dbf file in my job. the server is on AIX. i tried to use the ODBC Enterprise stage,but it works on a DSN.

please let me know how can we configure DSN on the unix server.

Hi Sri,

thanks for responding. please send them to my email bitnbyte at gmail dot com

thanks in advance

Hello, i could get an evaluation copy of transformation extender. but the tutorial is not the same as the datastage tx7.5 tutorial which is more detailed. i have the tutorial, but i dont have the actual files provided with the 7.5 version. can anyone share them please? i am looking for the files ins...

Hi

our firm would like to evaluate Datastage Mercator/TX. Can we get a demo/trial version of the same?