DSXchange

Hi What is the order of execution of Upsert strategy ( Update and Insert / Insert and Update) I have implemented the UPSERT strategy for the Dimension load. Iam using a oracle sequence as the surrogate key. In the Target stage i have specified seq.nextval for the surrogate key First Run: Source Reco...

Upsert Strategy- Order of Execution Hi I have implemented the UPSERT strategy for the Dimension load. Iam using a oracle sequence as the surrogate key. In the Target stage i have specified seq.nextval for the surrogate key First Run: Source Records =3 Oracle Sequence ( surrogate key) 1 2 3 Second Ru...

Hi In my parallel job iam using a lookup stage to lookup against my DataSet. Please find below the warning iam getting on the successfull completion of the job. Is it because of the Multiple rows in the DataSet for the same data.? LookupStage Warning: Ignoring duplicate entry at table record 8920; n...

Thanks a lot ray and T42. I have implemented the changes CDC + joiner to pick the other fields and later linking . Its perfectly working now .

Thanks

Hi Iam using a CDC Stage to implement the SCD . I have a two input datasets . Both are having almost 20 columns . But i specified the change values for only 2 columns based on the Key value . In the CDC stage i get the following error for all columsn other than the key colum and change value columns...

Hi

To load huge volume of data , kindly suggest the preferred stage

1) DB2-Load
2) DB2-Enterprise Stage (Load method)


Thanx
Maharaj

Hi

We have DB2 Enterprise/DB2 API stages in Parallel Extender. Kindly recommend in which scenarion we should go for these Stages. What is the advantage of using an DB2 Enterprise stage than DB2 API stage.

Thanks

Maharaj

1. Is there any feature in DataStage 7.0.1 which supports the Restartability?

2. How do we implment restartability at a Job level?

Thanks
Maharaj

thanx a lot .

regds
Maharaj

HI

Is it possible to convert the existing Server Jobs to Parallel Jobs?

1. If possible how do we that?
2. Is there any restrictions involved in that?.

Thanx in advance
Maharaj

Iam having special characters(&,<,>,..) in my data extracted from the source (DB2 database). Iam using a DB2 stage for this . I want to remove this special characters and control characters if any during the extraction from the source and before the creation of the XML File. Iam using a XMLWrite...

Hi Thanks a lot for it . :) Iam facing the same issue in my XML written using the XML writer stage . I want to remove all carriage returns other than those following a closing tag. How can I do that in DataStage BASIC. Thanks in advance . Maharaj Umm... You could post-process the generated XML code...

Hi Iam facing the same issue in my XML written using the XML writer stage . I want to remove all carriage returns other than those following a closing tag. How can I do that in DataStage BASIC. Thanks in advance . Maharaj Umm... You could post-process the generated XML code to remove all carriage re...