DSXchange

I have a job that uses the Uverse function SPLICE in a BASIC transformer. When I run this job on Development, the job works fine irrespective of whether I set it for Sequential or Parallel processing (Stage - Advanced tab). The development server uses one machine and the job is typically configured ...

I am posting this message because there is no forum for "Information Server Manager" I am using Information Server Manager to deploy code from Development to Production. I follow the standard practice of performing a "Build" on Development, copy the package from Development serve...

>> But I have observed that datastage is taking maximum row length. cdw, How were you able to determine this? Could you please elaborate on how you checked the space in scratch disk. I have noticed that it is hard to relate the scratch disk location to the actual job that generates it. Thanks,

Here is the situation I have a parameter set. Let us say, psA There is one parameter defined in this parameter. Let us say, firstParamA which has a value of "ABC" I have another parameter set psB which has one parameter firstParamB from which I need to get the value of "ABC" If I...

Possibly Column Import to parse the record and Pivot. That's just an initial thought, and probably requires you to preserve the newline characters. Thanks Ray! I think I am pretty close. I did not quite understand what you meant by "preserve the newline characters" initially, but now I am...

Thanks Ray! Appreciate your response. I will go ahead with the purchase of "Lookup Stage DVD"

Row generator will produce 2 columns which are 1.) a dummy column (say constant 1) 2.) sequence from 1 to n (n = max possible list of values in the column you wish to split) Add the same dummy column to your input row. Join them, use the sequence column to field() and add necessary constraints. You...

I am planning to purchase two Category "C" DVDs. I definitely want to get "Reading the SCORE DVD". But I am torn between choosing "Lookup Stage" and "Systematic Design". I have perused the video sample and the content of "Systematic Design", but I am...

Sainath.Srinivasan wrote:Or join with a row generator and do a split the fields.

Hi Sainath,

I have a similar requirement and I am trying to follow your note. How does a row generator help? What is the column to join? Since Row Generator generates arbitrary (mock) data how could we use it for the task at hand?

Thanks,

[quote="ray.wurlod"]Leave the @FM characters - they will be converted to newlines when you write to the text file. Make sure that you specify 000 for delimiter and quote characters in the format and None as the record delimiter style.[/quote] Hi Ray, Thanks for the reply. Is there a way to...

Hello Gurus, (I have gone through the forums and read all about vertical pivots before asking this question. I have also perused the manuals - BASIC reference and Parallel Job Developers Guide) The requirement is as follows Input [code] Col1 Col2 Col3 A B 1,2,3 D E 4,5,6,7,8 [/code] The field delimi...

Thanks Ray! I could use IConv and OConv to perform the looping 1. I used two user variables fromdate = Iconv(FromDate,"D YMD") todate = Iconv(ToDate,"D YMD") 2. Used a Start Loop (sa) to loop from "fromdate" to "todate" with Step=1. 3. Used OConv to retrieve t...

[quote="datastage_learner"]calculate the total no. of days and run loop activity counter for total no. of days that you get. That may solve your issue.[/quote] The issue with this approach is that the date is of a non-standard format and hence needs conversion. I will work on Ray's suggest...

Thanks to all! [quote] If I am getting you correctly, then there is no inability... but rather a behavior. Most of the Stages are specific in their behavior. [/quote] I am probably constrained in my thought process because I consider providing two output streams as an "ability". That said,...

I see comparisions of Lookup and Join in several discussions and in the manuals. I think one of the fundamental differences is the inability of Join to provide multiple output streams (one output and one reject) whereas Lookup stage provides for this functionality. Am I correct? I use Lookup stage c...