Search results for query: *

when I check the event viewer in server after running the task with "Run whether user is logged on or not" option, I see application error with the below details: Faulting application OUTLOOK.EXE, version 12.0.6423.1000, time stamp 0x49b08185, faulting module OUTLOOK.EXE, version 12.0.6423.1000...

HI, I've a simple batch file which calls the below vbs script to send email using MAPI. I've scheduled the batch script through windows scheduler and it's working fine when I set the task as "Run only when user is logged on". I manually run the job from task scheduler, and I get email everytime...

Hi, I have number of files in a dir name ends with ?.err where ? is single literal. For example, the file names are: MMLGO_3010_20100201100500.3010.5.err MMLGO_3010_20100201100500.3010.7.err I want to get the name MMLGO_3010_20100201100500.3010 Facts: The length of...

Hello guys, Can anybody tell me if it is possible to read all the sheets in an excel file as a source ? Let's say, if I have 3 sheets (sheet1,sheet2 and sheet3) filled with data in the input excel data file, would that be possible to import all the data (from 3 sheets) in the mapping designer ...

Hi All, We are presently working to find out the strategy for migration of an informatica ETL application from version 6.2.1 to 7.1. Please can you help me regarding the following 1. What would be the steps for migrating the application. The present version is installed on AIX ver. 4.3. The...

Hi All, Is there any function in C which will return the RANK of an array ( like Oracle RANK Function ) . Eg : Array[0] = 121 Array[1] = 122 Array[2] = 122 Array[3] = 125 Array[4] = 125 Array[5] = 126 It will return like Array[0] ----> RANK 121 ----> 1 122 ----> 2 122...

Hi All, I need to load data into a table depending upon a particular date . suppose in the flat file I have last 100 years historic data . But I want only last 50 year's data , into the table .For that I wrote the control file , but it's not working . LOAD DATA INFILE 't1.out' INSERT INTO...

...is a create table statement : CREATE TABLE TEMP PARALLEL 64 NOLOGGING PARTITION BY HASH (EMP_ID) PARTITIONS 64 STORE IN (MRI_D) AS SELECT /*+ PARALLEL (emp, 64) PARALLEL(detail,64) USE_HASH(emp,detail) */ emp.emp_id emp_id ,deatil.house_id house_id ,detail.first_name first_name...

...the number from this field using REPLACE or TRANSLATE or any function in the SELECT statement. eg, the input string is : ' 1 :: 2 3 Adfre 34 * & )( -= bd ' It should return only the numeric field 12334 I tried with SELECT TRANSLATE(string,TRANSLATE(string,'0123456789',' '),'')...

quiet time of the system" It's not possible to do this . Because this table needs to be created in the middle of a cycle . In 72 hours of total duration of the process , this table needs to be created after 24 hours(approx) .

...? ph_extract_tmp1 table is properly partitioned and indexed . DELETE ph_extract_tmp1 A WHERE EXISTS ( SELECT /*+ USE_HASH(A,B) */ 1 FROM ph_extract_tmp1 B WHERE...

.... SQL> create table ph_extract_tmp1 parallel 32 nologging PARTITION BY HASH (AOL_INDV_ID) PARTITIONS 32 STORE IN (IM2_D) as select /*+ PARALLEL(a,16) PARALLEL(b,16) */ a.* from ph_extract_tmp1_org a, dup_ph_tmp1 b where a.rowid = b.row_id 2 3 4 5 6 7 ...

...SELECT custacc.aolindividualid ,custacc.accountid ,custacc.serviceid ,custacc_tmp.registrationdate FROM customeraccount custacc ,( SELECT /*+ PARALLEL(customeraccount,16)*/ aolindividualid ,max(registrationdate) registrationdate FROM...

...calls 0 db block gets 94 consistent gets 7 physical reads 0 redo size 399 bytes sent via SQL*Net to client 344 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 7 sorts (memory)...

...custacc.aolindividualid ,custacc.accountid ,custacc.serviceid ,custacc_tmp.registrationdate FROM customeraccount custacc ,( SELECT /*+ PARALLEL(customeraccount,16)*/ aolindividualid ,max(registrationdate) registrationdate FROM customeraccount GROUP...

That's true sbix . But I think DOP is related to these two things parallel_threads_per_CPU and parallel_max_servers . Anyway I don't have solid idea regarding this , I went through some manuals . There I found regarding parallel servers .

...data. We have no. of CPU = 20 parallel_threads_per_CPU = 2 (NOT SURE) parallel_max_servers = 40 A.Now What should be the DOP here ? Is it 20*2 = 40 ? B.Which one is preferable from the following options to decide the no. of partition of the table , to acheive best performance : 1...

Hi Sudhi, select TRANSLATE(')81$!.-.=5*;.#-38.(-489','1234567890!@#$%^&*()-=_+;,.', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' ) FROM dual;

...,inlastname ,rownum row_number FROM individual WHERE aolindividualid NOT EXISTS ( SELECT /*+ HASH_AJ */ aolindividualid FROM individual_tmp ) ...

...,ind_teln.rank nightrank ,ind_telc.inputphone csiphone ,ind_telc.erank csirank FROM customer cust ,(SELECT * FROM individual_telephone WHERE typecode='D') ind_teld ,(SELECT * FROM individual_telephone WHERE ypecode='N') ind_teln ,(SELECT * FROM...