DSXchange

I think you can do by making multiple jobs. 1. Create a dataset as the target. 2. Get the distinct first column values from dataset and delete records from target table by using using criteria (where targettable.column=datasetfirstcolumn). 3. Insert the values from dataset into target table. - Pavan...

Use the transformer stage. You can use parameters in transformer and also if condition. You can use if condition to assign value to new column. Make sure that you handle nulls, if not transform stage may drop records.

Thank you guys, will stage the data before I load. You can do this. When you use Oracle Enterprise stage, Oracle reads the data at the point of time, in other words, you are reading the snapshot of the data, when you issued the SQL statement. You can update the same table with the data. You will no...

Hi, I tried to use NLS map. But did not give correct results. I applied NLS Map on Oracle Enterprise stage. When I looked at the data in excel, I see chinese characters but these are not correct. I did check with SAP instance by logging into SAP instance with that language. I applied Oracle (my data...

Hi All, We are in particular situation. We do extract SAP data using CDC tool. SAP database is Oracle. We want to load the extracted data into datamart. Db for datamart is Oracle. We are using Datastage PX job to load the data. I tried with different combinations but could not succeed in loading for...