DSXchange

Hi, I am getting type conversion warning when transforming data from table to table. I have used SCD stage and the data type are varchars only. I am getting a warning like this. Can anyone please tell me what would be the problem. Thanks in advance. ##I IIS-DSEE-TFCN-00001 12:50:41(000) <main_progra...

Hi,

We are getting many instances of osh.exe on the server. Can we delete them..? please explain about this...

Regards
Rudresh

Hi, Thanks for the reply. We got there but it did not help. We got to the datastage credentials and then chose our server. We are not using a shared registry. We tried changing the password of one of the usernames and then through Client aministrator/ designer tried logging in. It did not allow and ...

Hi, Got a strange problem here. We were not able to log into the project as it said the username/Password are invalid. Then , on web console we chnaged the password for the username under 'user group' tab. Still the condition is the same. The repository DB is already up and many files exists under t...

Thanks for the response Ray.

What do you suggest... Shall I take it up with the support then? this is something That has to be implimented ASAP...

Can you suggest any workaround.

Hi, I am using SCD stage to do type 1 updates on a particular table.The business key field is of type varchar. When changes on the attribute takes place instead of update a new row is inserted but with business key value NULL. I tried changing the datatype from varchar to integer (since value were c...

Hi, On execution the job succeeds with status as OK. The data inserted is also fine. But in the designer, While executing, no information on the number of rows inserted is displayed. there is one warning in the director log, Main_Program:Failed to initialize job monitoring. Monitor information will ...

Hi Dean,

Thanks for the reply.

1a is aleady installed in the system. Do we need t install any other patch along with this. Or Could there be any other reason for this error.

Hi, i want to parameterise the filenames in the SCd stage where, for surrogate key generation a flat file is used and the source name is set to the name of the file using which this key is generated. I used a ENV variable for filename and there was a compilattion error. But when using a job paramete...

Hi All,

I have created a job with SCD stage. The target is ODBC Enterprise stage (For SQL Server). For around 50,000 records, it is taking 7+ minutes. Can we do any more tuning to make it less than that time?

Thanks in Adv.


Regards

Rudresh

Hi, I have 5 sequences, each one of them has many jobs and most of these jobs are to be executed simultaneously in parallell. When the 5th sequence which has the other 4 sequences in it is executed, it can be observed in the director that 6-10 jobs execute at the same time. This does not affect the ...

Sorry again. "I am using ODBC enterprise as my source, and here i do not have any options for Disable operator combination. I have already disabed the schema reconciliation by setting to 'NO' both 'fail on type mismatch' and ' fail on size mismatch'. " Its the same result. I have got it to...

But the job fails on execution, though both the source as well the destination are of type float. The error message given is APT_CombinedOperatorController,2: Fatal Error: Accessor type "sfloat" does not match interface field type "dfloat". Everything is fine in the job, Can anyt...

If there is a float field in the destination, i am getting the below error. APT_CombinedOperatorController(1),1: Fatal Error: Accessor type "sfloat" does not match interface field type "dfloat". If i convert it into integer, it works. But i need to convert it in to float datatype...

Hi Again,

I couldnot able to do this. can you please explain briefly...


Thanks Adv

Rudresh