DSXchange

Hi All, I have a text file which containts values for 2 dates.say like PDATE , SDATE(Purchase Date,Service Date) and stored as timestamp format(eg '2002-04-20 00:00:00:000', '2003-05-22 00:00:00:000' .Now i want to find the Difference between these 2 dates(SDate-PDate) in Months.Can anybody help me ...

Thanks Ray,

Lemme ask my DBA to look into it.

Regards,
K.S.Rajan.

Dear Ray,

I am really Sorry Ray.I admit my mistake.I know that in this forum people are giving solutions before 24 hrs for the posted questions.

Here after i don't do that way.

Thanks & Regards,
K.S.RAJAN.

Dear All, The Soruce Table Contains 1,14,835 Rows.I am trying to do ETL.Both Source and Target Tables are in Oracle.But I am getting the Following error. SQLSTATE=S1000, DBMS.CODE=1114 [DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-01114: IO error writing block to file (block # ) Can anybody he...

Hi All, I designed Job using DataStage to do ETL from Relational Oracle schema to Star Schema.I finished creating jobs it is working fine.I want to do incremenal backup of the tables.I hope u can understand what it means.ie I want first time Insertion (Update Action of ODBC Stage) 2nd time onwards i...

Dear All, I have more than 85,000 Rows(SOURCE oracle TABLE) each Record length is more than 450 bytes.Now i want to transform this table to another target(Oracle Table).I designed the job using DATASTAGE.It is running fine but it is slow.Is there any paramerter I can tune so that my ETL will become ...

Dear All, I have a Table Which contains Reference to Other Tables.I need to populate a New Table Based on This main table and the Reference Tables. Eg.. Main Table 1 Ref Table2 REf Table 3 COL1 COL1 COL1 COL2 COL2 COL2 COL3 COL3 COL3 COL4 COL4 COL4 COL5 COL5 COL5 REST OF COLUMNS In The Above Strture...

Dear Vincent McBurney,

I proceeded(STEPS) as you said in your mail and It was successful to load Data thru DS.Thanks a lot for your valuable mail at the right time.
Thanks a lot Vincent.

Thanks & Regards,
K.S.Rajan.

Dear Ray,

Right now I am in New Jersey,USA for a short term assignment.i will be back in India on March 11th/March 13th 2003.Ray I am in Southern Part of India.It is called Chennai(MADRAS).Bombay is 1100 KMs from my Place.

Thanks & Regards,
K.S.Rajan.

Could U Please help me in the above issue.It is very urgent Ray....

Thanks & Regards,
K.S.Rajan.

Could U Please help me in the above issue.

Thanks & Regards,
K.S.Rajan.

Hi All, I have 2 Oracle Schemas.I need to do ETL from one oracle(Relational Schema) to another Oracle(Star Schema).In Source Database I have 3 Base tables from which 16 Views are derived and I need to Move the Data from these sources(So 16 Objects) to target of 19 Tables. So Do i need to design 19 J...

Dear Ray,

I made my datatype as Timestamp.It is working fine now.

Thanks a lot.

Regards,
K.S.Rajan.

Hi,

I tried with the following Default format 'YYYY-MM-DD HH24:MI:SS' and assigned a value to the TimeStamp Target filed it worked.

Thanks for your help,
K.S.Rajan.

Hi All, Could you please help me how to give Default value for a date Target column.In Oracle we can give sysdate right.Like wise I am asking.I assigned OCONV(@Date,"D2") to that column but is it giving the following Error message. SQLSTATE=22008, DBMS.CODE=0 [DataStage][SQL Client][ODBC][...