DSXchange

can you please explain more about the approach?

I am using an Oracle enterprise stage to load data into table using RCP. This does not have an inbuilt commit. So we are using the APT_ORA_UPSERT_COMMIT_LEVEL environment parameter. Based on the load size we may need to change this value. this is the requirement behind changing the environment value.

Hi,

I need to change the value of an environment variable at runtime. How can i achieve this? How can i chnage the values of them in a parm files in unix. I am using parameter sets and parameter value files in datatstage, and corresponding paramfiles in unix.

Hi. I have a job that is used to load data into oracle table using the oracle enterprise stage as it supports RCP. I am using an insert query with decode statement in it. The job is running fine if i use the insert query directly in the Oracle enterprise stage. But I need to pass this query as a par...

Thanks to all of you.. I am using a DB2 API stage in Datatstage version 8. This is used as a target stage. For the current day's load i need to delete the target table's older contents and load today's data into it. I used an update action as "Clear table and insert rows" but it is throwin...

sorry a typo error.. i am not getting your question.. please clarify..

I am gettin your question.

ok. so if same values are returned for the same set of keys what are you supposed to do?

I am issuing a delete * from table to clean up the entire table and then begin the insertions for the current day load. My point is the entire table should be deleted and only then the insert should begin. ! Will it be achieved here?

Option 1: Use a join stage(inner join). Partition and sort the records based on the key fields in the input link of transformer Use stage variables and check if the current records keys match with the previous records keys- if yes write the error columns with the desired value (key1 : '+' : Key2 : '...

Can you please be more specific on your requirement? i understand that when there are duplicates for a key from the table you will need to join with another table with those keys and fetch the lookup value from there?

Hi. I am using DB2 API stage with transaction size as 100. I am issuing a pre SQL delete that is used to delete the contents of the entire table. And a normal insert statement is used to load the data. what is actuallly happening here? will it delete 100 records and insert 100 records and then commi...

@ Chulett- I need to convert the string in the format of mmddyy to date of fomat yyyy-mm-dd

I am loading it into the table which has date in the above mentioned format. The source is mainframes here.

Hi
I am getting a date in the format of mmddyy. I need to convert it to yyyy-mm-dd format. How can i achieve this?

Hi,
I need to filter records based on some conditions to three different path. Which is the best stage to use, is it the transformer or the filter?? The data input that we handle is around 4 million.