DSXchange

Actually i was having data in a single stream only....but Teradata Enterprise Stage Silently drop all the duplicates....
Thats y i separated the data into two different streams....one for faster load (around 95% of data) and one for slower load(duplicate records)

Hi Is there any way that i can load a same teradata table 2 times in a single job.... The reason i need this is that i want to load duplicates in the table and if I use Mload for all the records than it effect the performance... So what m trying to do is load the remaining data using the Teradata En...

The logic seems fine....jst make sure ur data is sorted

Ray is right without sorted data u cant remove duplicates using transformer.
What you can do is sort the data on key and then use two stage variables to remove the duplicates.
one having the last value and one current and by comparing both u can remove the duplicates

Hi
Try this. hope this helps

StringToTimestamp(DSLink442.a,'%mmm %dd %yyyy %hh:%nn:%ss:%SSS')

Make the target column as Timestamp Extended

Hi

The issue is now resolved after installing Fix Pack 1(FP1)

Thanks for all your support.....

In Datastage Administrator go to properties of the project, now here in environment variables set APT_DB2INSTANCE_HOME = (path of your database installation for example /home/ibm/sqllib)

have set all the parameters in ulimit file as unlimited for root as well as dsadm user in both the servers i.e.datastage and database
The problem still exists....
Thanks

We just migrated our development environment to V8.1 from 7.5.2. Have done all the configuration known to me. We have one Datastage Server(04) and one Database Server(05) Everything is running fine except the SORT Stage. Sort is running fine if i change Sort Utility from datastage to Unix. We are ge...