DSXchange

Oh I for sure did not get the premium membership because of this, but I was told by a colleague of mine but alas, could not find them here.

Do you know of any place that could provide rule sets for Latin America countries?

Cheers

Hello,

I was told that as a premium member, I would be able to access some predefined rulesets for individual countries on this website.

Is this true? After searching, I am unable to find any mention of this at all. Could someone help?

Thanks!

Below presentation describes how to manually delete a DataStage job for all versions of Information Server DataStage.

http://publib.boulder.ibm.com/infocente ... layer.html

Hi - What is the resolution? Can you please elaborate? Thanks,

Hi there, I reckon whenever the rule set is changed, [Separator List] and [Strip List] in the [Advanced Options] are changed as well. Therefore, it causes that strange error I encountered. I've been given advice that one should take a look a the 'advanced options' in the job design, click the [Resto...

Julio, Thanks for your reply. I appreciate it. Yet it didn't help me out so much :( . I've checked Datasets directory of the project and haven't come across with any *.v file(set) or dataset. However, I've done one more design with different rule set for instance CANAME or USNAME set and run it. Sur...

Hi there, I wonder you guys have any experience with EXPCOM (Expanded Company Name) Rule Set. I'm trying to use this rule set in Investigate stage for word investigation to see Pattern Report to output the columns for a pattern report and Token Report to output the columns for a token report. Yet I'...

I have tried to exit and restart the websphere datastage designer for several time and the error solved by itself. I don't know how it could be happen. I can access "C:\IBM\InformationServer\Clients\Classic\QS_TEMP" and create folder in Client Computer. What is the resolution? I'm encount...

I can recommend using WinSCP which is an open source free SFTP client and FTP client for Windows. It has its (basic) text editor too.

Hi colleagues- I have to implement the below requirement- There is a file having column "AREA_CODE" which has values like US929ABC US12GH123 USA99CBH09 US999 I need to incorporate the below algorithm using DataStage functions on this column values- Check needs to be applied on 3rd,4th and ...

Loading to one Oracle node (not making use of both nodes of Oracle RAC) with full parallelism on Datastage end worked fine now. Oracle has asked us to apply the patch so will do so in two weeks time and till then we load to one Oracle instance only. I will leave this post open and close it after we ...

Our DBA's think we might have hit the Oracle bug

Bug 5973648 - ORA-54 during concurrent parallel direct SQLLOAD in RAC [ID 5973648.8]

DBA's have opened a case with Oracle support so will let you know how it goes.

Today we will try to use only one Node to load data and see if it helps

Best Regards

We reduced no of nodes to 3 from 5 and somehow it is working now. Also our DBA's have opened a case with Oracle. I cannot believe the table is used by anything else and every time a different table. Mayble a combination of Unix Server Load with Oracle client version (which is 9.2 and DB is 10g). Wil...

Sorry for false hope, the jobs failed again even after change but at different further table now.

Any help would be much appreciated

Thanks

Hello,

We may have found the cause.

This pasive schema had indexes with "NOPARALLEL" set when active schema had all with "PARALLEL DEGREE ....".

Now we changed it all jobs look fine so far

Best Regards