DSXchange

we are using 8.5 ....................is Balance Optimizer any thing called new stage ?

well two oracle connector using join stage to 80 million records. In each oracle stage its just a simple select statement. First Oracle connector stage 188 M will be populated in 12 to 13 mins and other oracle connector stage it populates 90 M records in 10 to 12 mins to reach join stage. One strang...

I am facing strange Issue. First my job is aborting due to ORA-02396: exceeded maximum idle time, please connect again. Well Coming to my job design. Step 1: Doing Inner join on 2 tables and I will get 140 million records and I get distinct records ...... finally I get 80 million records. Step 2: Th...

Thanks each and every one.

I am opening new thread regarding performance issue of a job. see u shortly

@kduke Thanks your your reply.

So far in our project we are using Variant as 10 and our oracle is 11g.

We never faced issues with this?

Thanks priyadarshikunal. I got your point, Whenever I interact with you. I will get chance to explore further. Now I got one more question. I will use 11 as variant for now. In future the oracle client changed to some other version then you suggesting "somesoft links", I am not clear with ...

My oracle client is 11, So at every stage Oracle connector should I use 11 instead of 10.


What do you mean by "I would not recommend"....... Do you want me to use only 10 ?

Hello Everyone,

Can anyone tell me what is the meaning of "Variant" in Oracle connector.

It has values 10 and 11................what does it mean ?

I have a small question on SORT stage. I am trying to get only unique records but in my stage property I used Execution mode as Parallel.

Here my question is ?

Does it really removes duplicates after sorting or should i change to sequential ?

Table A : 110 M Table B : 180 M I am doing INNER JOIN to get common records, it produces 85 million records. Problem: In 85 millions records, I am doing HASH partition(2 keys) and unique at Transformer. Next it loads to oracle database , when it loading it getting aborted after some time due to Erro...

I need a guidance on DB2. I need to get several tables information from Mainframs DB2 (via DB2Connect .....I am not sure what it is). Our Database is ORACLE. The DB2 tables are in different server. I need to recommend approach for our team how to get information to your database. For this scenario: ...

@priyadarshikunal: You Rocks !!!

You saved my time. Actually i have codes like 2 bytes : AB, CA, DE

after seeing your logic I got this idea and it works perfectly.

if Index('AB,BD,DE......EF ', trim(CODE),1) then 'N' else 'Y'

Thanks Chulett.

Its perfectly working, I used Index.

Once agian thanks everyone.

Thanks everyone for replying. Well In my case I don't think Index works in my case. Index will look for one substring Index (string, substring, instance)....I am trying to match upto 10 items.......If those 10 items matches I need to assign 'Y'. I am trying to find the function with matches a group ...

what do u mean by index?