DSXchange

My vesion is 7.0.1 and what I can see is
Add
Delete
Properties
NLS
Command

in the right hand side menu. Is there anything involved with the user rights.

Thanks
Siva

I had checked my Admin Client in Version 7. The clean up option is not shown. I had seen this in previous version but not in Version 7. If you come to knew let us know.

Thanks
Siva

DS Admin and DS Director is two different application. The one in the DS Admin client will clean up the projects. Which you need to select a project and then do the clean up project. Whereas in Director the clean up is used to clear the locks and resource.

Thanks
Siva

Hi


Use the @TIME function in the transformation step. Datastage has time() / timedate() function which can also be used.

Make sure you change the time to the correct format to your oracle database.

Cheers
Siva

Hi I think you haven't got my reply. The fact is while reading a sequential file from datastage job it won't give you any error. So the datatype doesn't really matter while reading from sequential file. But when you use the oracle stage then before inserting the timestamp field the source has to to ...

Yes you are correct it won't give any error while reading inside datastage. Make sure you give enough length in the sequential stage for that type.

Cheers
Rasi

First check the format of your oracle environment. Do a export from your oracle table which has the timestamp field. And check the sequential file you creating is same as the format of ORACLE. Accordingly do the changes to the format in your transformation. If you are viewing the sequential file ins...

Try spiltting one job which does 20 lookups into many jobs with few lookups on each job. This should help.


Cheers
Rasi

We had the same problem with version 7 while handling the space in the key fields. We had modified the job which creates the hash file to check if it is space. If so we send some special character to the column and in the lookup job we had the transforms to check from the source if it has space then...

Yes you are correct. I checked their site and got the following information. ER/Studio allows a database to be reverse-engineered into a model for the following platforms: Native Microsoft SQL Server 6.5 & 7.0 & 2000 Sybase Adaptive Server 11.x Oracle 7.3 & 8.x DB2 Common Server DB2 UDB ...

Sybase Power Designer 10 has the option of Red Brick. But it is not certified.

Where can I get more info about ER/Studio from Embarcadero Technologies.


Thanks
Siva

Unless you send the input PeriodNum in text format and treat the transformation as text format you can't without in-built function. Can use Oconv or Format function to do this.

Thanks
Siva

We currently Datastage 7, Redbrick 6 and Erwin 3.5.2 as the data modelling tool. Since Erwin doesn't redbrick anymore is there any tool available for redbrick.

Thanks
Siva

If you have duplicate records in your source and want to update the target table using insert new/update existing option then the last duplicated record in your source will be active in the database table. If you want to avoid duplicated of your existing table then yes you need to put you existing p...

This process doesn't check whether you have duplicates records in your dataset or not. If you have multiple records with the same primary key in the source then it will update the target table as many times. The last record which comes from the input will be active in your database. To avoid this yo...