DSXchange

Thanks Kumar for your reply I shall try using those other stages that you mentioned and see how it works.

Thanks Keshav for your reply. I found the answer for my question. And yah there are many ways you could do different things for eg joins and all but I was interested only in that specific stage.

Well the rows are unchanged w.r.t to keys and values that you define in a CDC stage but there is other information associated with only in the before data in the DB. For eg. in any slowly changing dimension you would have the record creation date or the record update date which is system generated a...

Hi I have noticed that in the CDC stage only after dataset records or information comes out of the CDC stage. Is it possible to output both the changed rows from the after dataset and unchanged rows from the before dataset be outputed by using a single CDC stage? If so what would be the combination ...

In the aggregator stage there is in the option section wherein you could select the method to be sort instead of hash. Now before you run into this aggregator use a sort stage and sort it on the the grouping keys of the aggregator. The partitioning into the sort stage hash it on the grouping keys an...

Is there an existing basic routine or function in datastage that would help me convert the GMT time to local time (considering all the timezones) INCLUDING THE CHANGE IN THE OFFSET WHEN DAYLIGHT SAVING OCCURS. My understanding that GMT time doesnot encounter any change during the daylight saving. An...

Hi In order to stop and start datastage services we have regular process of checking for any processes running on the box. we do ps -ef|grep ds netstat -a|grep dsrpc all that stuff. these processes and all check for any processes running inside DSEngine that are locking the port before we bring down...

Check if your TNS_ADMIN ( which ever you assign to your tnsnames.ora file directory or file) variable is pointing to the right directory where you have the tnsnames.ora file.This ora file while drive the conectivety to the database.Go through your errors in the director carefully i.e. when your job ...

Hi The patch that you should be adding is to the desnv file on the Sun OS box.Log in as datastage admin and view your dsenv file.In the file you would have LD_LIBRARY_PATH,to it you need to add '/usr/lib/lwp' for light weight processes. But you need to make sure that /usr/lib/lwp has been installed ...

In version 7.5 I have used the external filter stage to initiate or call a shell script from datastage

Hi You havent specified what unix OS you are using.If it is Sun OS then there is a patch that has to be installed on the server and included in dsenv file LD_LIBRARY_PATH.But if you confirm that it is a sun OS then I could post the reply for you to check if the server has the patch required and then...

Hi I have an input of 5 fields to the aggregator stage of which 3 I am using the group by function and 1 field I am suming up the input field to an output field. Now the remaining one field I would like to count the no. of rows (i.e. have a counter to count the no. of records in the grouping ) that ...

Hi I am trying to use the upsert command available in Oracle stage in DS version 7.5. What I am trying to do is insert if it is a new record and update the table if it is an existing one.But for some reason it is inserting the same records into the database but not updating if it is the same. I have...

Hi If you have that error cannot get exclusive rights for the job, and you do not have any one logged onto the job then it means that there are active locks on the job that need to be removed.Go to bin/uv inside DSEngine and Do a list.readu at the prompt that you get after bin/uv and get the user no...

Hi
Yes the substring function exists in 7.5 but the only difference is is syntax.As said earlier in one of the replies to the question the syntax is

ColName[starting character,No. of positions]

This would take care of substringing in the transformer stage for sure.