DSXchange

Hi Abi,
Thanks for your response.
There is an Utility has devloped by ACG that will perform such Conversions. I'm also not clear about that.
So if any one knows Regarding this please help me.

Regards
Suresh

Hi all,
Please help me,
how to migrate Informatica to Datastage.

Regards
Suresh

Hi Ray,
I tried,these are the fatal errors i'm getting.
Teradata_Connector_34: Properties /Usage/WriteMode, /Usage/Session/ArraySize: Incompatible property values

Teradata_Connector_34: Error occurred during initializeFromArgs().

Thanks
suresh

Hi all, My source and target is Teradata.I'm trying to execute the job it is aborting.My fatal error is onnector_22: [IIS-CONN-TERA-005004] RDBMS code 3803: Table 'X' already exists. SQL statement: CREATE TABLE SEBI_EDW.X (X_Id INTEGER NOT NULL, Lifecycle_Cd VARCHAR(50) NOT NULL, X_Type_Cd VARCHAR(5...

HI all, I wanted to convert the date 2008-01-21 23:59:59 into 2008-01-21 in datastage server edition. my source and target is Teradata. I tried by using a flatfile(target) it is working but it isnot supporting for database(teradata target).By basing on date i have to load data. So please help me how...

Hi,
Thanks for your response.For yyyy-mm-dd i'm using as "D YMD[4,2,2]"
Can you help me in converting this format (yyyy/mm/dd hh:mm:ss)
as yyyy/mm/dd.

thanks
suresh

Hi all,
How to convert 2008-08-10 07:53:08:230 into yyyy-mm-dd
(2008-08-10).Please....

Regards
suresh

Hi all, My source and target is Teradata. While executing the job,seems like execution it loaded around 5lakh records after that process have stopped.I'm geting the blue line after that process is stopping.Its not even showing error.I try to abort the job its not reponding.I want to run the job succ...

Hi all,
What are the major differences between 7.5 and 8.1?


Regards
Chandra

Hi all, My source is DB2,Which is mirrored into oracle by using Data mirror.For our source DB2 we are not having keys.That is the reason we mirrored into oracle.Now we are having both surrogate key as well as natural key.By using this keys we have to do scd-1 and scd-2 for all the tables.And we have...

Hi all,
I'm having three different source tables.In that daily insert update and delete operations takes place.i have to capture these changes
into a single target table.For some tables i'm using SCD-1.and for SCD-2.
So how can i achieve that.


Thanks in advance

Hi all,
Please tell the process,differences and advantages between ETL and ELT.



Thanks in advance

Hi Kandy,
Any other option with Datastage.

Thanks

Hi all, My source is DB2 and Target is Oracle.In my source we have no primary key(PK is defined by human). Some table have UNIQUE KEY but there are transaction that update rows at these UNIQUE KEY's fields . Each table is having 100 to 250 million rows with different operations like insert,update an...

Hi all,
Can any one help in brief about Change Data Capture Stage in DataStage.