DSXchange

Hi everyone. I got a reply from tech support on this one, it's an issue with the c++ compiler. I have been waiting about 3 weeks or so now for a resolution to this. Fortunately I will be migrating to Linux boxes which should resolve the issue. The text of the problem as defined by tech support follo...

I'm no expert on AIX, but it sound like a reference to a library or something is missing. Check your environment variables maybe?

A basic question, I think I know the answer.
When I am comparing fields in a change capture stage and I have a field that can have a null value, will the change capture consider this an edit because you cannot compare null to null?

I got this solved. It was because the update statement was trying to use the orchestrate field to update the sequence, which I did not want to do. Once I removed that set statement everything works good.

Hi all, I know this question has been asked 100 times and I am going to ask again because I have some issues... I know in past posts that it says the best way to handle using an Oracle sequence is to use the custom sql in the Oracle stage. But, I get the following error: Oracle_Enterprise_40: Orches...

Thanks for the replies. So if it does promote the executables then I would not need the c++ compiler on the test and prod machines as long as I don't check the re-compile option. Correct?

Thanks,

Another question in order to promote from dev to test to prod, is a c++ compiler required on all the environments or can I get away with it just on the development server?

I was looking more for the hardware requirements to promote from dev to test to prod and what protocol it uses.

tcp/ip
ssh etc.

Thanks

I was looking through the docs for the VC tool. I did not see any requirements for how to promote projects. Is the protocol used just tcp/ip?

Thanks.

I think I solved my own problem. I did not have the Oracle lookups set to sparse! So it tries to cram everything into memory.

Thanks

I'm loading a fact table. So I have 9 lookups into the dimensions to get the surrogate key values. The job runs fine then I get: fact_table_fk_lookups,1: Could not map table file "H:/IBM/DataStage/Resource/DataSets/lookuptable.20060509.uhq5v4d": Not enough space Operator's runLocally() fai...

I was able to solve this one by parsing the date out and adding the place holders as necessary.

If anyone is interested in how I did it let me know I will post the code.

Thanks.

If I have a text string which is a date coming in from a sequential file as such : 1/1/2006 and I want to use the StringtoDate function on it, It appears that I will have to manipulate the date to 0 fill both the 1's so that is appears as such: 01/01/2006. Is this correct? Or is there are format for...

I have a job where I have an Oracle Enterprise Stage->Surrogate Key Stage->Transformer->Oracle Enterprise Stage. In my transformer I am converting integer values into dates the format is YYYYDDD. In my derivation I am using the following: if DSLink26.CIRAMST_DATE_LAST_BNOTICE =0 then setnull() else ...

Thanks for the hint on the function.
Here is my derivation. Does this look right?

if DSLink2.CIRAMST_DATE_LAST_BNOTICE =0 then setnull() else DateFromDaysSince(DSLink2.CIRAMST_DATE_LAST_BNOTICE[5,3],StringtoDate(DSLink2.CIRAMST_DATE_LAST_BNOTICE[1,4]:"-01-01"))

Thanks!!