DSXchange

Hi All, I have a sequence that triggers 3 jobs in parallel. All the 3 jobs uses the same lookup tables. When I ran the job, iam getting a fatal error Fatal Error: Fatal: ORA-00022: invalid session ID; access denied But When I run them individually they are running fine. Could someone help to resolve...

I tried changing the data type from double to float, after changing the values looks like the following:

Source Value:0.5805555556
Target Value:0.580556

I have done the direct mapping, the value doesn't match. Please let me know.

Regards
Cherry

I tried with loat as well. It gives implicit conversion warning

Regards
Cherry

Could some one suggest me what to do


Best Regards
Cherry

Hi All, I have a field defined as Float at the database level. When I import metadata using Datastage it is taking as Double . When I compare the source values with the target values there is a data mismatch. My datbase is Oracle 10g. Could some one help me how to resolve this issue. The Data looks ...

Thanks Chullet

Hi All,

Using Email Notification activity can i call a text file that contains list of recieptents email addresses. If yes how can Specifyy the list of addresses in the file. I mean is there a format how I can mention all the address.


Thanks in Advance...

Best Regards
Cherry

Hi All,

I have requirement to read the Excel data and load to a Oracle table.
Is there any stage in DS to read the excel data, If yes please let me know how I can achieve.


Thanks in Advance..


Best Regards
Cherry

Oracle Error :: SQL-02146 Attempt to allocate an existing descriptor Cause An attempt allocated a descriptor which has previously been allocated was encountered. Action Use and unique descriptor name or deallocate the descriptor before attempting to reallocate it. ORA-00022: invalid session ID; acce...

Thanks Chullet. Let Me try this.


Best Regards
Cherry

Hi All,

Could some one provide me a sample script to execute Datastage jobs from command prompt.

Thanks In Advance...


Best regards
Cherry

Thanks Chullet, Let me try and get back to you. Thanks for your patience in Helping my things done.

Regards
Cherry

Hi Chullet,

You mean to say, I need to check the "Do not Check Point" Also

Please confirm me.

Regards
Cherry

Status shows as Aborted/Restartable. Sorry for that

Yes Chullet, The Master sequence is in aborted state


Regards
Cherry