DSXchange

Thank you. That's exactly what I want.

I have the following scenario. Seq file A is transformed by B and some records are passed to the next transformer stage c while others are constrained and written to seq file E. Similarly some records and constrained by transformer c and written to seq file F. seq A | V transformer B ______ seq E | ...

I also tried Edit Column Meta Data but Date Field type has 'Non available' in properties and the Value field is greyed out which means I can't specify the Null value. Any idea anyone?

OK I tried to put a null handling function in the transformer stage, yet still getting the same error. I used NullToValue(Lnk_in.Field1,'1999-01-01') in the transformer derivation. I also changed all the fields to non nullable, but still no avail. Could you explain why the DATE_FLD has been changed ...

One of the switches in the Oracle stage lets you enable the reject link, look for it towards the bottom of the list. ... I found in the documentation that I have to change the Write Method to 'Upsert' to enable the reject link. when I did that I am getting the following error: Message: Oracle_Ent,0...

Thank you for the prompt response. When I added a reject link from Oracle enterprise stage, i got the msg: "Error: Reject Link Ora_ENT.DSLink9 is not allowed wiht the current setting (or lack ) of the 'Output Reject records' property". I don't seem to be able to set any reject link propert...

I have the following scenario: I have a sequential file which consist of a date field in yyyy-mm-dd format. The file has 2 rows as followed. Row 2 is an invalid date. 2005-10-14 2007-25-12 I want to insert the data into an oracle table which has a date field. I passed the seq file straight through a...