DSXchange

The other way is to use the refernce input as source or use join stage full outer join instead of lookup

What is the array/transaction size you have set for delete operation?

The Link collector Stage can be used independently if you have set the row buffer inter process property active in job properties. from what I recall what Link collector does is an SQL 'UNION ALL' functionality not the SQL 'UNION' functionality. So you might have to design your job to remove duplica...

What do you want to delete. delete all the records or just one record?
What is your target?

Access database do use tables. Even Excel worksheets can be read as tables. I thought you were using some macroes kind of stuff to get data in Excel to Access and then using the Access file as source in DS job.

But as mentioned by Craig, you can use ODBC stage to access both of them.

What do you mean by Excel Data in MS Access ?

can you check if there are any hidden characters in file on UNIX.

cat -v filename

also check character count on the file to see if it matches with the length you foun from DataStage

I am considering Buskey 51 for example BusKey|ChangeKey|StartTS K1|Data2|2010-07-30 09:12:12 K1|Data3|2010-07-30 11:12:12 union with existing dimension data BusKey|ChangeKey|StartTS K1|Data1|2010-07-19 09:12:12 if required add remove duplicates stage here based on data analysis. then sort on Buskey(...

Hi, The job description is as follows Source -- DRS for SQL server Reference -- DRS for SQL server Transformer -- performing lookup operation Target -- DRS for SQL server I am using lookup input link variable NOTFOUND(=0) in transformer constraint to segregate records which has a match from which do...

The issue has been resolved.

The solution is very trivial. may be that is the reason we overlooked it. The plug-ins were nt working because the PATH variable was not updated.

No.. I will get the clients installed.
Is there anything else nees to be taken care of such as updating dsenv, restarting the server etc..

Hi, What are the requirements for teradata plug-in stages in Server 7.5.2 version. The plug-ins are registered on manager, which are also visible in pallete. When I try to import table defintion using 'Plug-in Meta Data Defintions' option and selecting Teradata, it gives below error. Unable to initi...

Siva..Check if you have any open query(pre load) in target stage.
it could be possible that this is added in development for testing purposes.

If you want to truncate then why do it in first job.
you can do the same as well in second job either by using any of the solutions mentioned above or simply using the Load method with truncate option.

You can check if the particular warning is downgraded to information or suppressed from log on 7.5 V. If it is the case then you can do the same in 8V.
The mentioned activity is done on director. not sure whether it will get migrated when upgraded from one to other.