DSXchange

Hi, I trying to load an oracle table using an ODBC stage. Job design is pretty simple - reading from a sequential file and mapping to oracle table (odbc stage) using a parallel transformer. No. of records that get inserted is correct, but all fields are carrying null values - inspite of the source (...

Hi, We have a requirement in our project wherein a source file having a single header record and multiple detail records have to be matched for batch date and update date respectively. Current job design is as follows:- 1.Source file read using Complex file stage (using redefine feature of Cobol fil...

May be partiton screwing up you process :? Just for testing purpose run you job in sequential mode and check the result. Is the value being empty for all the values? If so pls check the datatype to which the columns are mapped to. -Kumar Following are the settings under which I'm running the job:- ...

Have you checked to see if the problem is happening in your PX transform stage or in the pivot stage? It might be because the conversion isn't working correctly in the PX stage. Yes, I have used Peek stage to view the records after every stage(transform and pivot). The data is coming out correctly ...

Hi, I have got a csv file to be loaded to Oracle table. One of the columns has to be split in 48 different values/columns and then those 48 columns have to be transformed into rows. I tried implementing the above via both server and parallel job using the following scheme: Sequential File Stage > tr...