DSXchange

Clear the partitioning on the links that are coming to Lookup stage.

What is the purpose of TMPDIR in Administrator.This is avialable in Environment valiable under general category.

You can use file pattern to read all the files in a partcular directory. Using file pattern this can be done.

I am using NextSurrogateKey() in expression nothing else.

In Transformer, use 2 output links and write first 8 chacacter is first link and rest character in second link and then use funnel stage to combine both the output.

The input link Columns page contains three input columns with sales data: JAN_Sales, FEB_Sales, and MARCH_Sales. The columns are as follows: The data for the source rows for the input columns looks like this: Input Source Rows CUSTID LNAME JAN_Sales FEB_Sales MARCH_Sales 100 Smith $1,234.00 $1,456.0...

Before loading the data into DB, use SetNull() function to set the null values if date/timestamp is null or if it is not valid date.

This problem is not occuring for single job but also occuring for all the jobs where we are loading the data in Load append mode while working fine when we change the mode to Upsert.Actually we have 2 schema on same database and tables are also same in both schema. In one schema we have public synon...

We are getting the following error while loading data into Oracle table using Load and Appened method "Error when checking composite operator: Caught parsing exception during wrapDescribeOperator(): Could not find type: oratype:0". When we use upsert method, table is loaded without error. ...

Use local parameter in sequence and then assign these variables to Parameter set's variable.

You have to set Oracle Database path in Environment variable and also have to set ORACLE_SID,LIBPATH and ORACLE_HOME in user defined variable to work with Database on windows. All these information are available in document under Oracle Enterprise Stage.

I am working on 8.0 version and used SCD stage. Its is working fine for me and generating 2 records for type2, one with old SK for update and one with new SK for insert.

It means you DataStage server is not working properly. If the service is getting stoped after restarting again and again, It means you cant login. I also faced the same problem so many times but still i dont know the solution. Everytime we reinstalled the DataStage server again and it works fine then.

We have also faced the same problem. First you should use Complex flat file to read the data. If your data consist packed decimal values then read the data file through Complex flat file stage and Charcter Set should be EBCDIC and Data Format should be Binary.

Today I run the loading job in Sequential mode in stead of parellel mode and data was loaded sucessfully without any error. Is there any problem with parellel mode when using upsert mode?