DSXchange

Please suggest manuals that would assist me in learning writing various transform, Before/After routines. Are there any other methods?

GREAT!! Thanks for the response.

I went through a number of posts for delimiters, missing columns,et al. A number of problems and an exponential number of solutions for them have been suggested. It would be really great if someone came up with common problems that can occur with such and suggest solutions.

I am using the necessary function(RowProcPreviousCompare) for comparison. My understanding is that the previous value for ID will be there after the first row is processed. Did I miss anything?

Hey, is there a simple way to reposition the columns that is got from the metadata. Only thing I could do is insert columns, but with all the typings. Importing metadata does not provide solution since it maintains the original order. I require it for maintaining the column order to be used by the B...

Got it working. I used stage variable on sorted records. That was easy..thanx for your help guys.

How would you write a routine for the same?

I have 2 stage variables sv1 and sv2, each of which maintain the previous IDs, say empID and storeID, respectively. I need to use a logic such as- If (sv1=True And sv2=True) then 1 Else If (sv1=True And sv2<> True) then 0 Else 1. The code I used is- If (sv1 AND sv2) Then 1 Else If (sv1 AND NOT(sv2))...

THanks ketfos, the char(128) works. I still haven't understood the reason behind it thogh. Hi, Did you try using the char(128) as suggested earlier. There is another way as follows - if that does not capture the null data if (Trim(DSLink2.hiredate) < char(33) or Trim(DSLink2.hiredate) > char(127) ) ...

The source is ODBC pointing to SQL Server 2000, and the data type for hiredate is Timestamp. The SQL Server does show NULL in some records for the hiredate field. However, the check that I specified seems to fail to capture that, and takes the else path. Even with this, when the hiredate is NULL, I ...

THankx Arnd, I got it right. Hello Gateleys, the simplest and most efficient method would be to sort the incoming stream by Cust_ID and then to use a stage variable to store the last Cust_ID value and to do a comparison on this value with the current Cust_ID to see if this has changed in order to do...

Hi, I have 2 dates, graduate_date and hiredate. I need to find the number of days between the two. However, if the hiredate is NULL, I need to set the numOfDays to 100, else Difference in days between the 2 dates. Everything works, except that the NULL condition in the hiredate doesn't seem to be ch...

My input records are as follows, with multiple records for each customer. Cust_ID Cust_Name Value 1 AA 100 2 BB 200 1 AA 50 Now, for the first occurence of each Cust_ID, I need to multiply Value by 5. However, for subsequent occurence of each customer's ID, I just pass the values as they are. So, my...

Hey Ray,
I did what you told me, but I still get the same compile error -Job contains cyclic or linear dependencies. I feel the there is something wrong with my writing to the hash any ID that is NOTFOUND. I tried to manage it as a reject also...no success.

ODBC ----->Transformer---------->seqFile inlink | | outlink | | LookupLink | | WriteHashLink(to write NOTFOUND id to hash) Hash The constraint in the outlink contains LookupLink.NOTFOUND (for the ID). If the hash is populated, initially, with the IDs of each employee, then each ID from source will f...