DSXchange

I'm not sure that I understand what it is that you are trying to do. Could you provide an example because I'm sure that would help?

Your calculation should not be too difficult. You can do a simple calculation like you describe in a transformation stage. The derivation for your output column will look something like this: If InputLink.Column1 = 'xxx' Then If InputLink.Column2 = 'xxx' Then InputLink.Column3 - InputLink.Column4 El...

You can only use a hash file stage to do an equal lookup. To do a range lookup you would have to use a different stage like an ODBC stage or the UV stage. You will have to change the SQL to be user-defined and then replace the equal join generated with a greater than/less than join to fit your needs.

Datestage will issue a warning message saying 'zero rows updated' if I use an ODBC stage to do updates and the key being updated doesn't exist in the table. I expected this same behavior when doing deletes. I used an ODBC stage and changed the SQL to user defined so that I could issue a delete state...

I agree with Charley. I would try to avoid Null values in your tables and would convert any null value to the 'NA' when populating your fact table. One other thing you may have to consider is if the column you are converting makes up part of your key in the fact table, you have the potential to crea...

Since you can write to a flat file but can't write to SQL Server maybe the problem is with SQL Server like a lock on the table that you are trying to write to. Are you able to write to this table using something other than Datastage like Query Analyzer?

You would not be able to turn the column names into data in the pivot. You can do what you describe in a transformation stage after the pivot using stage variables. The first would be a counter and the second would be a big If statement to assign the description. The following is an example with jus...

where should i write this command ?

You can enter these statements through the command window in Administrator.

You could do it by inserting a hash file into your process. You would write a record out to the hash for each or your three output stages. The key would be a constant indicating either stage1, 2, or 3 and you would have a count field which you could populate with @OutRowNum. Then everytime it writes...

Datastage does provide some system variable that may give you what you are looking for. @InRowNum and @OutRowNum will give you a count of the number of rows that come in and exit your process. You can also do it on your own using stage variables. If you have more detail on what you are trying to acc...

I worked with Oracle Warehouse Builder for the past three years and honestly, I prefer many of the features of OWB over Datastage. We were able to do everything that we needed using OWB to develop a fairly complex data warehouse. That being said, I would never pick OWB to develop a warehouse again. ...

You can create your 'Sub' column after the pivot using a stage variable in a transformer stage. Name the stage variable like SV1 and initialize it to 0. Then the logic would be something like 'If SV1 = 3 then 1 else SV1 + 1.' This will give you the 1,2,3 for each group and you can just cancatenate t...

You can reset it through the command line in the administrator. The command is: UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = 'key_you _want_to_reset';

You can create your 'Dealer' column after the pivot using a stage variable in a transformer stage. Name the stage variable like SV1 and initialize it to 0. Then the logic would be something like 'If SV1 = 3 then 1 else SV1 + 1.' This will give you the 1,2,3 for each group and you can just cancatenat...

You can use the pivot stage to convert columns to rows. Converting rows to columns is a little harder. There have been numerous posts on that topic in this forum. Do a search on 'vertical pivot'.