Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by himridul

  1. himridul

    MAPI is not working from task scheduler

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

    MAPI is not working from task scheduler

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

    substr string from end of the string

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

    How to read multiple sheets from source excel file

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

    Upgrade from 6.2.1 to 7.1

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

    Implementing RANK function in C

    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...
    • himridul
    • Thread
    • Replies: 1
    • Forum: C
  7. himridul

    SQL LOADER PROBLEM

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

    Create table as select /*+ parallel/ from

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

    Retrive Only Numeric Fields from a String

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

    Unable to extend TEMP tablespace

    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) .
  11. himridul

    Problem in deleting duplicate rows

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

    Unable to extend TEMP tablespace

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

    Not getting the correct output through this query

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

    Query Optimization

    When no. of rows =3 in the table customeraccount table , this is the execution plan Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=5 Card=1 Bytes=42) 1 0 HASH JOIN (Cost=5 Card=1 Bytes=42) 2 1 VIEW...
  15. himridul

    Query Optimization

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

Part and Inventory Search

Back
Top