DSXchange

ray.wurlod wrote:Describe your job design more completely. There is not enough information in your post for any meaningful diagnosis. ...

The job has a source,transformer and Target.
Source fetches subset data(with some conditions) from the previous day's target table.

Hi,
One of my Server jobs is finishing with a warning as mentioned below :

ORA-00001: unique constraint violated

Can anybody help why the job has finished with warning while there are no source records.
The tool version is 7.5.3
Please let me know if there is any bug of this kind.

Tell us exactly how you are handling that value: data type in source and target, transformations, IConv/OConv, source and target sql, etc etc. We would need an appropriate level of details from you in order to be able to help in anything more than a very generic manner. I am fetching data(timstamp ...

That's the first time you've mentioned that 01841 is an Oracle error code. What does the oerr command tell you about this code? ... Sorry Ray, anyway this is the error i am encountering : ORA-01841: (full) year must be between -4713 and +9999, and not be 0 The source data has many records which con...

Use the interactive Debugger (in the Designer client) to see what is happening with the data on each link. ... Hi Ray, I am getting the ora 01841 error mentioning the date is not the valid one.Do we need to load the date column into target only after parsing into char or is there any possibility fo...

Hi, I am facing problem while loading data into the target database,which is oracle.THe stage i used is Oracle OCI.may i know th issue why i am unable to load the timestamp into the target.I suspect the date coming from source is being converted into internal format. But now i need to load the date ...

You can't do what you are doing with HF2 without a much better understanding of the fact that hashed files are metadata driven and how the columns are positional and thus don't operate like database tables. You are going to get yourself in trouble if you make a habit of writing to one with one set ...

Thanks Ray..

Further to my understanding..

If i define a column as and later change the metadata as then there wouldn't be any change.
If i change the to
Then there would be some minor change in occupancy of space.

Am i correct

after the disscussion made in http://www.dsxchange.com/viewtopic.php?t=128705&postdays=0&postorder=asc&start=15 ,I have a doubt that whether there is space loss in the repository when we increase(double) the size of one column. I believe only the metadata(given in source DRS stage) is st...

Forgot to say one more thing.
There are 6 columns in HF1,out of which I am using one 3(1,2,4)columns only in HF2.I am getting 3rd column's data in 4thcolumn(When viewed in HF2).

Hi Friends, I have an issue.I have 2 jobs,In one job i loaded a hash file(HF1).In another job i am trying to fetch data from the hash file(HF1) into another hash file(HF2) for a lookup.Now when I tried to view the data in HF2,My data with the metadat is not matching.Could naybody tell me where i wen...

No, when set to 'Oracle' the DRS stage uses OCI. When set to 'ODBC' it... well, I'm sure you can figure that one out. ... When set to 'ODBC' it...searches for open database.. Then What is the use of Oracle OCI when DRS can do the same job. And i also found when using the Oracle OCI stage instead of...

It's an interface and it is what the OCI stage uses exclusively. The DRS stage can use that or ODBC to communicate with Oracle. ... Hi Chullet, So you say that Oracle OCI stage has the Interface which DRS does not have in the stage,Is it? And this is the reason Oracle OCI may take less time to fetc...

hi,
Very strangly, I got the issue resolved.I had increased(double the size) the datatype size and ran the job,then it went successfully.Now again i placed original values and found no warning or error.

Finally i found there must be an issue with datatype size,As our Sainath told earlier.

Thank you

ray.wurlod wrote:What DO you think the Oracle OCI stages use?

Hint: what does "OCI" stand for? ...

OCI stands for Oracle call interface.and Oracle OCI is meant only for Oracle.But how does this doiffer from Dynamic RDBMS Stage(DRS),As both of these stages have to fetch from database. ???