DSXchange

Seppy,

Some of the jobs have filter the data using the LASTUPDDTTM in the PS_ETL_JOB_CTL. You may want to insure that you have run the LOAD_ETL_JOB_CTL_TBL server job.

Basicall what I'd like to do is populate the current date into a field if the hashed file is empty. I will try what Kim suggested and give an update.

Within my server job, I would like to perform certain logic if a hashed file is empty. What is the best way for me to test this condition?

In the task manager, it is in the "Running" status, but when l click on the work area I get no response.

I have tried it on several other PCs and it works fine.

Within the designer, I am able to open all of the available plugins except the DRS plugin. When I attempt to open it the application freezes. This is the first occurance of this and I have been using the application on the same machine for 6-8 months. I have rebooted several times and I have also un...

Within the designer, I am able to open all of the available plugins except the DRS plugin. When I attempt to open it the application freezes. This is the first occurance of this and I have been using the application on the same machine for 6-8 months. I have rebooted several times and I have also un...

In speaking with the business community, I found that there is a business requirement to define the SCD Type at the field level. Could someone provided some advice on the DataStage logic needed make the field level SCD decision within my server job?

What's the downside of treating any change as a Type 2 regardless of the column?

If my dimension table contains 4 non key attributes and one (or two) of those attributes require Type 2 SCD response, could I just treat any changed row as Type 2?

I'm in the process of finalizing a dimension loading process following Kimball's methodology. I have a question that may change my process. What's the affect of treating the whole record as Type 1 or Type 2 instead of individual columns on a record?