DSXchange

In that case, try usign a transformer to convert it to a string and write it into a sequential file.

Warning 2 can be handled in the job.
Is your preserve parition flag from your transforer is ser?
If so 'clear' it.

If you logged into DS.TOOLS the 2nd option is 'Rebuild Repository indices'

The poster says he is on Windows and Server only no PX. Windows makes a big difference. One machine means no network traffic after you have done your extracts.

Sorry I missed that... Thanks for correcting it.

I would suggest, you can 'handle' the first one but not the second.

Try to select your link as 'Multiple rows returend from the link' from Lookup stage condtition tab.

What you mean if 'MO is same for incoming rows '... Do you have any reference data?

Do you have all the 459 key match in the lookup data with in 145?
What is the condition given, if lookup failed, is it fail or reject or continue?
Have a reject file and mark it as reject and try to collect all the unmatch records in a seperate file and to a verification.

Close all you client connection.
From your command prompt.



TCL is case sensitive.

There shouldnt be much difference between the source and target fall under same server of different server, but more than that, its important that the datastage and database server installations. If both were at same server obviuosly its a cake for you. Else input and output should be retrived and t...

No this wont.
But how exactly you need your output to be.
Is it like new column to be inserted as AMT3,AMT4..... or it should be updated to AMT1 and AMT2 again.

So the executables are from DEV/TEST, in which RPC is turned ON.

So have you tried to loading the table directly into a sequential file?
What is the structure of the job?

I dont guess duplicate should also be an issue, because
SeqFile------>HashedFile worked without any error.

Let me reconfirm.
Is it view data succedes immediatly everytime, where as job gets aborted often. Am I right.