DSXchange

Hi all, I have a dimension for which key column can change. I have SSN (Social Security Number) and employee_num that are key columns in employee dimension. We have found that we ended up getting duplicate records for same employee when ever there is change in either of columns. Why change in SSN? D...

Hi, We migrated from DataStage Version 5.2 to Version 7.5. Transition was smooth and we had no issues for first 3 weeks. After that we have explored Restartability option and have made changes to jobs to take advantage of it.. We had a sequence which calls other server jobs and sends a email notific...

Try using Isolation level of 'Auto-Commit' in Transaction handling tab while updation. This can be of help

Thanks,
Sarath

Hi, We have used partitioned tables. Our partitions are based on time (yearly partitions to be more precise). We have used multiple instance jobs for loading each of the partition in parallel. One advantage we got is we have to code only one job (in a generic manner) to load all partions by coding t...

What Ray said is right. This error occurs if I use a code like

Case Arg1 = 1
Then Ans = 'abc'
Case Arg2 = 2
Then Ans = 'xyz'
In the baove code I havent handled a condition where Arg1 is neither 1 nor 2. This is a simple code.

Thanks,
Sarath

Hi, We are taking up upgrade from 5.2 to 7.5. One issue I observed is in the foolowing query Select col1, col2, col3 From tab1 Where -- col3 = 'a' and col4 = 'b' Here '-- 'is used to comment the line in SQL Server The above query was working perfect with 5.2 but not in 7.5. The reason possibly becau...

Hi,

The problem is sequential file is generated by some other team and sent to us. And we have no control over the format of the file.

Pls suggest me a solution.

Thanks,
Sarath

Hi,

We are upgrading from version 5.2 to 7.5.

What are the significant diff between these two versions? What are the points to be taken into consideration while porting the jobs coded for 5.2 to the newer version?

Thanks & regards,
Sarath

Thanks a lot for the reply. I will try that.

Hi , I am trying to call a Job Sequence (the one with GUI) from a Server Batch (a job in which we code everything in Job Control). It is returning a null handler. Also the Sequence I wanted to call is not listed the list of jobs displayed in the drop down. From this I was able to understand that we ...

Hi, I am new to Ascential Data Stage. I have a task to accomplish through DataStage job. Delete from mytab Where mycol = #Param# Right now I am accomplishing it by using a dummy select from an ODBC stage and passing that through a Transformer and then using Final ODBC to delete what I wanted. But I ...

Am afraid I am replying little late. What exactly is the warning message that is getting repeatedly printed? From that message at times we will be able to make some sense of the problme. One frequent reason for this kind of error is due to problem in a Routine that is being called (can be due to com...