DSXchange

Hi, I dont want to extract the last four characters of the string. But the no of characters in the string is not know. Can you let me know what function should i use to achieve this? For Eg: in the following string: FY200901041233501234 - the last 4 character i.e 1234 shoud be eliminated and the res...

Ok, But then why the special character is not being written to the Hashed file if its None by default. Actually we have three different datastge environment(Dev,QA & Prod). In two of the environment the special character is being written into hashed file as it is. But in one(prod) environment we...

So by default the NLS setting for HASHED file is NONE?

Where should i specifically set the map setting for Hash File, because i dont see any option for settign the NLS setting specifically for Hash File.

Sure, with Convert() for example... but why? They're not really equivalent and a better solution would be to load them as is. What issue are you having? ... The issue what am facing is , the special character is read from a oracle table and its being written as it is to oracle target. But in betwee...

That's it, eh? Not seen that before. Do any other warnings or errors come with it or just that is what is logged? Also, how often is 'often'? Do the jobs / times of occurance have anything in common? ... No i get this error only.. and there isnt any recurrence of failure and job success, seems to b...

chulett wrote:Best if you post the actual, unedited message from the log. ...

Below is the exact error msg i get from the log:

Type1FixedPriceCTCJob..Trf_Condition_Check: |couldn't set locale correctly

Hi, Often my DS job gets failed with the message
|couldn't set locale correctly, Can you help me how to resolve this error?

Ok thanks, and i posted this message in server Forum only, dont no in which forum its currently in

Hi, Currently am trying to do the following: Have source data as follows: ID Name FYM Qty Sales 1 A 200901 1 500 2 B 200902 5 1000 3 C 200901 4 150 4 D 200902 2 252 5 E 200903 9 785 6 F 200903 7 451 7 A 200902 4 410 I have to load into target as below: ID Name 200901Qty 200901Sales 200902Qty 200902S...

No the records are not processed, its taking the same amount of time to validate also. Stages used Oracle Source Stage, Sequential file for doing lookup and target Oracel Stage. The jobs does the following: Selection from a master dimension table with certain condition and does a look up from the Se...

Hi, I have validated some jobs from the sequence,but the job is actually running its not just getting validated(but in director log i can find the result as Validated OK) Scenario: The job takes 16 minutes to run, so in order to do a testing i validated this particular job, but the validation is als...

Hi,

I am trying to load a file which contains characters with Byte Order Mark
( ). Can you pls let me know how to indicate the BOM while loading into datastage, i tried with changing different NLS but the file is not getting loaded, pls help me out to solve this.

Thanks,
Senthil

Hi,

One of my datastage job is locked can you pls help me out how to unlock it?

If i click the click the job to open, it states that job is beign accessed by someone, but no one access it.

Hi,

I want to schedule jobs in datastage, can you guide me how to schedule the jobs in Datastage Server Edition ?