DSXchange

What are your cut-off values? Change the cut-off values and see if that gives you the desired output.

What columns are used for blocking and matching in reference match specification?

Here is the code under input patterns. *. CALL Periods 0*. ; RETYPE [1] 0 0*, ; RETYPE [1] 0 *- | - | RETYPE [1] 0 *W="NURSE" | W="PRACTITIONER" RETYPE [1] S "NP" "NP" RETYPE [2] 0 *- | S | - | $ ; ; -ARNP- RETYPE [1] 0 RETYPE [3] 0 *- | S | $ ; ; -ARNP RETYPE...

Hi Staurt, Thanks for your reply. I modified my original post with correct input data. This is happening only when the first 2 words in the firstname are same. I checked my classification table and lookup tables and I dont see any terms matching the formats AB/BB. I see spaces added after each word ...

I created a custom rule set based out of USNAME ruleset for name standardization. Input to the ruleset must be in this format - ZQ,FirstName,ZQ,MiddleInitial,ZQ,LastName When I pass repeated words to FirstName column, I see that the spaces are not preserved. For example, if I pass input string - &qu...

Hi, Can 3 tables be joined together in one data rule as below. TableA_colB in_reference_column TableB_colB AND TableA_colC in_reference_column TableC_colC If I do the joins individually in 2 different data rules I am getting correct result but when I use a AND condition and try to do the joins toget...

Hi Ray, Thanks for your reply. I couldn't really test the count() function so far as I see that the joins are not working. I have table A with 5 million recs and table B with 2000 recs. There is a key column in both the tables and using a join I have to test if every record in table B has a matching...

Hi, I have a query with joins on 4 tables and a couple of filter conditions. The query returns 5 columns as output and has a count(distinct(colA)) as one of the output columns. I am trying to implement this query using Data Rules functionality in IA and I was able to replicate the joins and filter c...

Yes, its a bug in SCD stage. We faced the same issue in our project and support confirmed that its a bug.

Thanks Craig.
We tried all possible options but the oracle trace files doesn't tell anything about the problem.

Since it has nothing to do with datastage, Can you please tell me what can be done to avoid this error? Any database related settings/ network settings that can be configured?
Thanks.

Did anyone encounter this issue earlier?

Oracle client is installed on the Datastage Server. If I restart the Job, the Job completes successfully.

Thanks for your reply.
But why other applications that connect to the same database server are not throwing the same error.

I am running a Job which reads the data from a dataset and writes the data to a Oracle Table. There are no column level transformations or filters in the Job. This is a simple Job which inserts/updates the source data to the target table on a daily basis. Dataset -> Transformer -> Oracle Enterprise ...