DSXchange

Is there any way to capture rejected rows during bulk loading MS SQL server?

You should look for the way to implement TYPE 2 SCD.

Ravi.K wrote:Change "Preserve Partitioning" to "Clear" at Advanced Tab of the Teradata Enterprise Stage.

Did not find the option Preserve partitioning" at Advance tab of Teradata Enterprise Stage.

I have a simple Teradata table load job. the job retrives data from a dataset and load to Teradata table using Teradata Enterprise Stage. Wile executing this job I get following Warning for Teradata Enterprise stage - When checking operator: A sequential operator cannot preserve the partitioning of ...

Hi I have a Job Parallel (datastage 8.1) writing in a table (Oracle 10g) by an upsert. I would to create e routine to capture some information as, for example, the number of inserted or updated rows, as they appears in the Job's Log. May anybody suggest me a solution? How can I retrieve these infor...

Best thing will to add non key fields in both of your source, and get the output containing key and non-key fields from these three stage.

Hope that will make you understand how these three stage works

Plus there are so many target tables. Looks like some table may have foreign key references between themselves. Is the data load is properly sequenced like first master then the details?

Is there any complex query with condition at the source OCI? How fast the data is being retrived from source database? You are doing insert and update at the same time. Is your target table are properly indexed on key columns particularly for update process? I will prefer to separate OCI stage or ev...

Check this earlier post - viewtopic.php?t=132811&highlight=validate+email.

can you please provide an example.
So that we can understand what do you meant by ADDRESS (OCCURS 3 TIMES).

I have a routine call DSuserstatus( Arg1) Ans=Arg1 that returns the value of the first job. then I assign that value to the uservariable in the useractivity as Job1.$Userstastus and pass it to the job2 as a job parameter Is this DSuserstatus( Arg1) a user defined routine? As mention by Ray there is...

natashab wrote:what should be done to make the job run without the truncation failed error?

Check the user rights/privilege of the Oracle user which you are using has the proper right to truncate.

Check with DSEDIT utility, if you can access the sybase servers.
DSEDIT utility is available at Programs>Sybase

Please check with support if Sybase client installtion is needed.
My suggestion is to install Sybase Client in DS server.

Very recently we installed DS on Windows, (although we have sybase client installed in DS server), and I am quite sure that we did not have to register specific dll, as what is being mentioned.

Is the installation is made recently? Was the server restarted after installation?