DSXchange

I am trying to create a job that will execute a Teradata v13 Stored Procedure that returns the full dataset (as if it had just been a select statement) which can then be loaded through MLOAD in Data Stage. The only way I have gotten a Teradata SP to actualy run is through the Teradta Enterprise conn...

I am not getting the Change Apply to working that way. I am not able to retreive any fields from the before record set only the changed recordset. Additionally I want to use the change_code values to determine various date fields (Create, Update, Delete dates), not to acutally perform any changes. S...

I am using a Change Capture stage and would like for it to pass through a column from the Before dataset. I am not finding where this is possible the only values that are made available in the Output tab are from the After dataset. Example: Before dataset Key_col Value_col Value2_col Value3_col Time...

I am loading data from a SQL Server database into Oracle through a parallel job. I want the data in the Oracle table to be truncated and then bulk insert the records from SQL Server. I have an ODS enterprise stage pointing to SQL Server, Transformer Stage, and finally a Oracle Enterprise stage with ...