Search results for query: *

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...

Hi , Following 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...

Hi, I have a input string . I need only 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...

Hi, Following is my De-Dup(Delete Duplicate rows) query . It deletes duplicate rows in ph_extract_tmp1 table on the basis of where condition. Now for 122 millions of rows , it's getting hanged . So can I use any analytical function to solve this problem ? OR is there any other way for De-Dup...

Hi , This type of query has run previously in the database . But now this query is getting the error message . We have 4 CPU's . I can't increse TEMP tablespace(not authorized to do this) . Is there any other solution except to increse the TEMP tablespace ? Though I've mentioned the tablespace...

Hi , Actually I need one row(for every customer) which has maximum registrationdate for a particular aolindividualid . If a customer registered more than once in a day , then this query is returning more than 1 rows . It is not desirable . The most important thing is that , the table has 200...

Hi , Following is my query , which is giving high cost : SELECT custacc.aolindividualid ,custacc.accountid ,custacc.serviceid ,custacc_tmp.registrationdate FROM customeraccount custacc ,( SELECT /*+ PARALLEL(customeraccount,16)*/ aolindividualid...

Hi, Is there any relationship between No. of CPU , DOP(Degree of Parallelism) and No.of partitions of a table ? The problem is as follows : I've a table , containing 30 GB of data. We have no. of CPU = 20 parallel_threads_per_CPU = 2 (NOT SURE) parallel_max_servers = 40 A.Now What...

CREATE MATERIALIZED VIEW IND_UNMATCHED_MV PARALLEL BUILD DEFERRED REFRESH COMPLETE ON DEMAND AS SELECT aolindividualid ,truvuebestadressid ,infirstname ,inmiddlename ,inlastname ,rownum row_number FROM individual WHERE aolindividualid NOT...

Hi, I've one table called customer and one table , i.e, individual_telephone. Now the data set of these table would be like this : CUSTOMER INDIVIDUAL_TELEPHONE ------------- -------------------------------------------- AOLID...

Hi, I'm doing direct-load INSERT on nonpartitioned tables that have local indexes. To avoid the performance impact of index maintenance , I'm dropping the index before the INSERT and then rebuilding it afterwards . " rebuilding it afterwards " - Does Oracle create a new index or...

Hi, A table has 500 millions of rows . Now I have to update around 0.4 million of rows in the table. Can you tell me which process would be faster for this criterian : 1. Delete-Insert (Deleting the existing rows and Insert the updated rows) 2.Merge(Update else Insert) Thanks ..

Hi, I'm running the query below in Explain Plan window: INSERT /*+ PARALLEL(emp,12) */ INTO emp SELECT /*+ PARALLEL(t_emp,12) */ * FROM t_emp; In "Other Tag" option in Explain Plan , For SELECT statement it's showing PARALLEL_TO_SERIAL But For INSERT statement it's showing Nothing...

Hi all, I've a query like this : select a.indid from master_table a, ind_phone b, ind_phone c, ind_phone d where a.indid=b.indid and b.tel='B' and a.indid=c.indid and c.tel='C' and a.indid=d.indid and d.tel='D' The master table has 100 millions of...

Hi , Is it possible to spool 2 files at a time?The table is in Oracle 9i and from the single table I want to spool the data in two files. If the table have 10 columns and 50 million rows then , one file will contain 7 columns with 50 million data and second file will contain rest 3 columns with...