DSXchange

If I understand your problem correctly you want to get the account name where the account number falls between your range begin and range end. To do this when you setup your ODBC stage, on the columns tab identify the range begin and range end as keys. Then on the general tab change the query type t...

If your input is an ODBC stage, rather than changing the sql to be user defined in order to specify the 'Distinct' keyword, you could just go to the columns tab and group by all of your columns. This will have the same effect as the distinct and give you the results that you want.

I recently attended a user group meeting offered by Ascential and this topic came up. Ascential currently does not offer any certification for there products but they are planning to in the near future. There is suppose to be three levels. The first is certification in a single product like datastag...

The hash file that I am using in this process is used to lookup the surrogate key for a 'status' dimension. In the source system, when a record is initially created the two columns that are my hash file key are not filled in and are assigned an empty string indicating a status of 'unknown.' So havin...

I am doing a lookup to a hash file to get a value using a hash key made up of two columns. If both of the columns that I am using for the lookup are an empty string, the result of the lookup is a record not found. If I replace the empty strings with a single space, the lookup will work but I am wond...

The way that I have gotten around this problem is after I import the table definitions, I edit the table definition by removing the database name and owner from the Table/File Name field. Then when I import the columns into an ODBC stage the derivation field is just the TableName.ColumnName. It is s...

I have a simple job that reads from one table and writes to another table. Both tables are SQL Server tables and I am using an ODBC stage to make the connection. Some of the records are failing to insert but when I view the log the only error messages are SQLExecute failed ... 0 rows affected. I run...

Thanks, this helped me find out what my problem was. I was trying to use the function in a transformer stage. There was no transform function defined for NullToValue but there was one for NullToEmpty. I created one for NullToValue and now it works.

This is how I am calling the function:
NullToValue(lnkLkpCountry.Country_Key, 1)

The error message is:
Array 'NullToValue' never dimensioned.

In the past I have used the NullToEmpty function with success. Now I am trying to use the NullToValue fuction and I cannot get it to work. I can get around the problem by using an "If Isnull" statement but I am wondering what I am doing wrong. Can someone give me an example of how to use t...

If I use a counter in the transformer, would it be guaranteed that the order of the rows would always match the order that the columns are in? So would the value for Col1 always come through first followed by Col2, Col3, and so on?

I am creating a job to convert a single row into multiple rows so I am using the pivot stage. My input looks like this: Key Col1 Col2 Col3 A 1 2 3 B 4 5 6 My desired results are: Key Col Value A Col1 1 A Col2 2 A Col3 3 B Col1 4 B Col2 5 B Col3 6 I am able to do the horizontal split but how can I po...