DSXchange

RemoveDupBUOMErrs: Key field "SOURCE_SYSTEM_CODE" was not found in the view-adapted input schema Key field "SOURCE_COMPANY_CODE" was not found in the view-adapted input schema Key field "FROM_CODE_VALUE" was not found in the view-adapted input schema Key field "ERR...

thank you

Hi I have loaded data into tables through SQL Server as a Stage in Datastage. Now i need to delete the data and reload with new data. I actually use toad to view data and stuff... So can I just write in the toad the delete statement for that particular table and execute.... the table also consists o...

May be you have to change the datatype in table definition ... I think it is not able to take a large value

Hi

Can anyone please tell me how to call or Use a DSRoutine in a Datastage job.

Thanks
aschand

Hi, I need to reload the table definition. I have around 560 columns to be mapped so is there any way to do with out losing the mapping. Datatype has been changed in the target side. So i need to reload... Is it OK to do using Propagate values in the transformer stage... will it result in correct da...

Are there any online classes to be taken... if so please let me know.... Im completely new to Datastage and learning things and working at the same time.
Anyways Thanks for your suggestion.

Do i have to replace source with row generator and see?

Thanks.. It got solved

There is no data in the source table. But i still want to see if RCP is working when chosed and column is propagated to the target side... when column propagation is done. How do i do that?... Do i definetly need to have data in source to check or there is any other way to identify it? Please let me...

Hi Can any one please let me know what does this error mean and how i should rectify it. This was the compilation error that i got. Stage Variable vMTART: if isNull(lnkMatched.MATERIAL_TYPE) then ' ' else trim(lnkMatched.MATERIAL_TYPE) Variable 'lnkMatched.MATERIAL_TYPE' not defined thanks and Regar...

I mean when is the data read... is it during the Compilation or during runing of the job in DS

In Server or in parallel ... when are the values read?

During compiling the job or during running the job in the Designer?

How about in DS Director?

Thanks
aschand

with datastage i have loaded the data into SQL Server table. i want to run datastage again and relaod it... Now how do i delete the existing data which is present in the table and reload... it does also have the data came from other source i should be able to delete only my data that i have loaded t...

my job design is like this. I have 6 sequential files joined together using join stage and then from there it is loaded in a sequential file .... it ran perfectly when i removed the sequential file and placed a transformer(in place of sequential file and then to a Sql server enterprise the data is n...