DSXchange

One job. Two output links from the transformer based on the conditions you mention, each link ends in a connector. So, you'll have a connector for inserts and one for upserts.

Are you able to run your job on just a single node?

The mapping for the DATE type from Oracle is described to be timestamp in the connectivity guide from Oracle (Oracle Enterprise stage)

Just guessing that it might be the same when using the ODBC Enterprise stage.

Which stage/connector are you using? ...and from which database are you trying to extract data from?

The state file was introduced on DS v.8, and does not exist on v.7x

However you can create a new state file using the surrogate key generator stage and assign an initial value for the file.

example:

Field delimiter ','
Final delimiter '|'
record delimiter '\'

...having 3 fields would then give:

test1,test2|test3\

I think it is per session and not per user the warning limit are set.

Another option could perhaps be to use the function DSSetJobLimit?

That is a sparse lookup in DataStage... and I think the Oracle Enterprise Stage supports it.

The CDC stage cannot handle duplicate keys. You'll need to remove duplicates before processing datasets.

...and your user are still connected to SQL server when you try to import the table?
...and the DS user have the right permissions for the database?

Did you create a local or global tmp table?

You can use the WITH clause in the ODBC connector, for instance this CTE works... WITH Emp_CTE AS ( SELECT EmployeeID, ManagerID, Title, EmployeeID AS HighParent, 'Y' AS HighestLevel, 0 AS Level FROM dbo.MyEmployees WHERE ManagerID IS NULL UNION ALL SELECT e.EmployeeID, e.ManagerID, e.Title, ecte.Hi...

What can I say... using the ODBC connector stage and extracting from a SQL server database the it works.

p_List parameter defined in job properties: "001","002"

OCBD Connector:

SELECT ...
FROM ....
WHERE DER_AUTH_CD IN (#p_List#)

Well... neither does SQL server - however this actually works on SQL server...
Try it out!

You can also have a list of sting values passed as a parameter, you just have to put each of them in "" (that is the double quote character and NOT just two adjendent single quotes)