DSXchange

Hey chuck

I did get an answer to it. looks like the file system was full. It seems to be some space issue of the project in the server.

Thanks,
-Dj

Hi I have found another solution. I had created a lookup by running only 1 row for the keys into the hash file. Used the same lookup file for the job as follows Lkp UpdHash (copy of Lkp) \ / SEQ(Src) -->TRN-->SEQ (Target) | v SEQ(log for dups) ( the lkp and updHash point to the transformer, i dint k...

Hello All,

I was running a job of mine which involves loading data from source to a sequential file and came across this error message.

ds_seqput: error in 'write()' - Error 0

Please send your suggestions and solutions.

Thanks,
Dj

Thank you Bland.
I shall try with that.

-Dj

Hi Bland, Here there are like 8 key columns. Do you think i should use those 8 for col_a, col_b ? And what do you think the unique_identifier_column should be? Thanks, Dj Job_Get_Dupes: OCI --> XFM --> SEQ Write SQL like select col_a, col_b, col_c, col_d, col_e, col_f, unique_identifier_column from ...

Hi Chuck, I tried developing such a job. I had run the job and there were like 2201 rows in the source and they wer all populated in the output hash stage and also into the sequential file. I had created the hashfile for lookup populating only the key columns data.I had used the same hashfile which ...

I too would be dealing with the same issue.
I had run a job with 3.3M rows and found that there are 500+ duplicates.
Is there a way we could design a job which would involve capturing the duplicate rows in a sequential file ?

Thanks,
DJ

Hi Folks, I ran a job which involves sending data from a flat file to an oracle table. I ran the job for 10 rows and it went fine without any warnings or errors. When i ran the job for 50 rows and above it gave me the following warning. ORA-00001: unique constraint (SYSADM.PS_CW_DRAFT_MSTR) violated...

Hi Folks, I had tried viewing the data after the server maintainance was done. Still the error windows persist. Well, i had replaced the DRS stage with ODBC stage and it did not give me any problems. Well, i would still like to use a DRS stage so, are there any suggestions which could help in making...

Hi Its not always blank. well, i had tried to paste the exact window with the error mesg but probably the forum does not allow it. It said something like Invalid SQLExecDirect. The Unix server is still under maintainance and i have not yet got a chance to look at my job again since yesterday evening...

Hi Ray, Thank you very much for the reply. Well, there has been some maintainance going on our unix server and i guess it could be the repository issue. I shall try viewing the the data from the stage once the maintainance is taken care of. if still it doesnt help i shall try using ODBC stage instea...

Hi folks, I just ran a regular server job with all parameters set. In this job i am moving data from a source table to a target table with all the reqd privileges. The database used is Oracle. I am able to run the job successfully but when i try to view the data in the source (DRS stage) i am unable...

Thanks for the suggestion guys. I will have to go through the jobs again to see if this can be achieved using a file instead of a temporary table.

Thanks again,
-Sumit

Hey

Its the DRS stage that i used.
sorry for not mentioning it in the earlier reply.

Thanks,
-Dj

Hey folks,

When i run a job of mine i had got the following error.

Transformer_1: 4|S|V|

any suggestions ?!!!

Thanks,
--Dj