DSXchange

Hi, I have a source table from oracle which have a column with data type timestamp with time zome "15/MAY/14 01:50:02.360645000 PM AUSTRALIA/SYDNEY" . The task is to read the table (Oracle Connector), perform some transformations (transformer) and load it into Netezza (Netezza connector). ...

Hi All, Our client needs an restarting/rerunning mechanism in datastage. The story behind this is.. they have a number of jobs in a datastage project which runs daily. This is in version 7.5.2. The problem is that at times some jobs finishes successfully but does not flag the sequencer which invokes...

ray.wurlod wrote:Do you have $, # or _ character in your password? ...

No I do not have any such characters in my password.. it is just alphanumeric

Hi All, I am getting the same error as mentioned in this older post. TDE_Target_Table: TeraSync:DB Call Error(success check) Info = 0, Code = 3003, Message = Invalid password. error code = 3003 But my password is correct... I tried hardcoding the password as well, but its still not working. Please h...

TF_Transformation: Error when checking operator: Could not find input field "Accnt_Num". Error when checking operator: Could not find input field "Crdt_Mngmt_Type_Id". Error when checking operator: Could not find input field "Crdt_Mngmt_Trtmt_Type_Id". Error when checki...

Thanks Craig for your reply... and sorry for the late response.. I have dropped the idea of implementing this through a stored procedure... Because as you said the column is just considered as another output column rather than an error message... neither could I find a proper way to utilise the User...

Hi All, First of all... I have seen many related discussions to the error I am getting, but none of them could really help me and that's the reason why I am posting this again. I am using Datastage 8.1 parallel. I have an SQL which is quite complex with multiple inner joins and calculations, but per...

Hi all, I am calling a Teradata stored procedure through the Datastage STP stage. For example: REPLACE PROCEDURE x.A( des VARCHAR(50) ,OUT ErrorMessage VARCHAR(500) ) BEGIN --- Deplay Error message if Table not found DECLARE CONTINUE HANDLER FOR SQLEXCEPTION set ErrorMessage = 'Table Not Found'; -- ...

Maveric wrote:Did you search here? Look at this post:

viewtopic.php?t=90117

If i'm not wrong i think the link tells about classroom session courses for the certification. India is not there in the list..
Is there any material as such or some books?

Hi All,

I would like to take datastage certification. Can anyone advice me which material do I need to study?Do I have to buy any books?
I searched in the net, but it dint give a satisfactory result.So please help me...

We have already tried that.When we run the job in sequential mode it takes 8 hrs to complete the job.But it takes only around 4hrs to complete when it is in parallel.Is there any other solution which you could think of?

There are no other warnings other than "main_program: Invalid character conversion found converting to ASCL_MS1252, substituting." We ran the job by putting sequential file stage instead of DB2 stage and it is running fine how many ever times we run the job with the same file. If not DB2/U...

Hi, We are getting the warning "main_program: Invalid character conversion found converting to ASCL_MS1252, substituting." while running the parallel job more than once with the same file.(First run is successful) The database which we are loading the file to is DB2 and we are using DB2/UD...