DSXchange

the rows are unchanged, because it is same in Before and after datset; how does it matter that it is comming from before or after datset.

Remove teh sorting stage, sort and hash partition at the input at Change capture stage. Make sure the partition ans sorting key are same and same order.

i have same problem when we upgrade to version 7.5.2 , it was not a problem in 7.5.1. check some records may not be convertible to date.
you can try this:

if DDate<19000000 then '1900-01-01' else StringToDate(InputLink.Column, "%yyyy%mm%dd")

[/quote]

Have you used proper Rtype, like Fix_zeros etc.

you can have a Trail stage to get the last N records.

Can you paste the exact query and the error you are getting here.... (as you said it is sparsed lookup, you must be passing a value from the mainstream record)

Create a routine to Read the maximum value from the table, and then call this routine in User variable Activity stage, and assign the return value to the parameter.

I encounter the similar problem, i don't remeber exactly, but it is related to the final delimiter only, try using different type of final delimiter, probably setting the final delimiter value to 'none' wolve the problem

Hash partition on the primay key ( you must have used in the update where clause), and set prpoer row commit size.

You can use change capture stage.

You can write a routine to call this oracle sequence, and call the routine in your job

did you try using the User variable activity, and when passing the values to parameter, use field function..

Thanks Ray. It worked

I have teradata table which has a column of type char(30), and in my job i have a transform just before inserting into this Teradata table. i am passing a value 'RSH_PROD_DTL' into this column, but when i query select * from <table_name> where <column_name>= 'RSH_PROD_DTL' ; it returns nothing and w...

which database and what stage you are using to load the data