DSXchange

Hi - We have a requirement to load CLOB data into Oracle table. I have seen the posts regarding CLOB in this forum but unable to proceed. If CLOB is having data less than 1.5 MB (approx) then job is working fine with LongVarchar. But whenever the data is coming more than that the job is getting abor...

I have the similar kind of requirement. I need to load a field in Oracle having CLOB datatype. While reading from source, I am using LongVarchar(2147483647). because the length can be 2147483647 bytes. But while loading into table using upsert in Oracle Enterprise stage, getting error like SQLCODE -...

Thanks Craig.

Hi - Can you please suggest how read .dbf files placed on local machine thru datastage? I am unable read the file through ODBC because we are not going to deal with Foxpro database. Only .dbf files would be transferred to DataStage server and we need to read them.

Please help. It's urgent!

How can I read the .dbf files even though it's placed on DataStage server? Don't I need to create DSN? If so, how? Please suggest.

Hi, I am facing an issue with loading one of Oracle (10g) table. The job processes 1 million of data in more than 40 minutes. For information, if the Oracle stage is replaced by dataset, then that dataset is populated in 10 minutes, but the moment it is changed to Oracle, processing time increases. ...

i don't see the basic transformer stage from customization steps? Do I need to install any pulg-in or patch? If yes, how?

I did the following to add Basic Transformer to your palette: 1. Create a PX job in designer. 2. Right Click on Palette window and select "Customization->Customize" 3. On the Top-Left window, click on StageType->Parallel->Process to But here I don't see "Basic_Transformer" Can yo...

Thanks for the suggestion of using External Filter stage. But a quick question: Wouldn't it be a hit on performance?

Thanks for the suggestion of using External Filter stage. But a quick question: Wouldn't it be a hit on performance?

Hi, I need to extract a substring from a string. For example: 'FAS960C' should be converted to 'FAS960' 'FAS960HC' should be converted to 'FAS960' Requirement: Once there is a transition from numeric to character, then we are going to stop the search and provide result till that poistion. Please hel...

Hi,
Pleae explain how to incorprate CASS stage in a parallel job? We have installed CASS stage but even after that we are unable to view the CASS stage in "Stage Types".
Can anyone throw some light on it?

Thanks,
Nasim

Thanks.
Please let me know which rule set matches against list of valid domain so that I can use it.

Thanks for prompt reply.
To get built in soundexs functionality, I have to use USNAME, USADD etc.
But here I have to use VEMAIL rule set. VEMAIL rule set is not generating any soundex fields. How can I get soundex value from VEMAIL?
This is my understanding.

Please share your note on this.

Hi, I need to insert @ and/or . (DOT) symbol if email addres doesn't contain that. For example: 1. xyz@gmailcom should be changed to xyz@gmail.com (here missing dot is inserted) 2. xyzgmailcom should be changed to xyz@gmail.com (here missing dot and @ is inserted) 3. xyzgmail.com should be changed t...