DSXchange

Thank you for the mail. SQL before window exists in server jobs and not in parallel. I have not looked into the drop constraints and rebuild indexes options in parallel.

Thanks again.

Hi
I would like to know the difference between a lookup and join. This not concerned with the stages in datastage but the definition itself. When will a process be called a lookup and when a join.

Thanks
Bob

Hi I am working with the Oracle Enterprise stage and would like to truncate a table and then insert records into it. I tried the load option in the stage but it gives an error. I would like to do this by including custom code in the oracle stage, first truncate then insert records.How do I do this? ...

We are able to run all the jobs without any problem, but when we insert a transformer stage, the job does not compile and it gives the above error.

Hi I am working with Oracle enterprise state and would like to do a custom insert sql. Under the current options we can only do a insert in the upsert mode but we need to do include custom update statement also. I was wondering if I had to do a custom sql insert statements only, how will I do it. Pl...

Hi I have been working with SCD2 and have a difficulty in updating the old record and changing the delete flag on the deleted records. We have 3 columns that track every insert/ update for insert: eff_date=sysdate exp_date=null delete_flag=No for update: insert new record eff_date=sysdate exp_date=n...

Ray
I have gone through the vertical pivot posts on this forum but they donot specifically talk about comparing values in the first column, rather they are simple vertical pivots.

If would appreciate if you could help me in this regard.

Thanks

Hi We made a fresh DS EE install and have designed a parallel job. Oracle enterprise----------->TX------------------>Oracle Enterprise The job has direct mappings without any transformations, routines or any logic. I get the error ##I TFSC 000001 22:05:28(007) <main_program> APT configuration file: ...

Hi I have a vertical pivot requirement. Table1 col1 col2 X 2 X 3 X 4 Y 1 Y 2 Table2 col1 col2 col3 col4 X 2 3 4 Y 1 2 0 If the values in the first col1 are equal then the corresponding values in col2 then should be mapped to table2 cloumns 2,3,4. If no values are found then it should be mapped with ...

I could successfully restore the oracle connection, by modifying the oracle environmental variables to point to the lib32 folder which has the 32 bit libraries, earlier its pointed to lib which contains 64 bit libraries. This is not in the dsenv file though but in the oracle environment variables.

Hi We have recently installed DS 7.5.1a Enterprise edition on AIX. Though we are able to access metadata through Manager and import it, we are not able to run jobs. I have gone through your previous posts but they were of not much help. Here is the error. /ds/Ascential/DataStage/DSEngine/bin > uv &q...

Hi
We have Oracle 10g and DS Server 7.5 edition. I was wondering if we could migrate the code developed in windows to an AIX platform (DS7.5.1) later.

Should we use dsx or xml files.What will be the issues.

Please inform

Bob

Hi
If we install Datastage EE edition, where will the repository be. Is it on the client machine or is it on every node in the architecture or only a single node?


Please inform.

Bob

Hi I am having problems after migrating the code from one datastage instance to another. I have a unix script that passes all the required parameters for datastage including database userids and passwords. Whenever I change to the new instance the new database instance I am using is getting locked. ...

Hi Is there a possibility to store a variable, lets say select count(*) from table value such that it is accessible from any job downstream in the sequence from where this variable is defined. If so how? I am trying to store record count value from a oracle database and use that value later in the s...