Search results for query: *

Hi, Platform: Win Server 08 Requirement is InputFile: File1 Contents: Row1: Col1_VALUE, Col2_Value, Col3_Value Row2: Col1_VALUE, Col2_Value, Col3_Value Row3: Col1_VALUE, Col2_Value, Col3_Value Row4: Col1_VALUE, Col2_Value, Col3_Value OutputFile: Loop No of rows in File1 (4) (...

Hi VB Gurus, I have few applications that where developed in VB 6. its pretty old code which i have developed long back. We have a public module where we have code like this. Cn as rdoConnection Public Sub Main() Set Cn=en.openconnection(...) cn.open() End Sub We used the RDO library for...

Hi Informatica Gurus, I have source data in normal case. I want to load upper case into the target table. I know only the below synarios. Dont know if there is any other way to improve the performance. Flat File Source. 1. converting into upper case using the TR package. 2. Using expression...

Hi Guys, My source is Excel(.xls) file Worksheet1 COL1 COL2 COL3 US SALES 19 UK SALES 20 INDIA SALES 30 INDIA PUR 20 INDIA INV 50 CHINA SALES 15 IF I GIVE SEARCH PARAMETER AS "INDIA" IT SHOUD POPULATE THE Worksheet2 WITH INDIA DETAILS COL1 COL2 COL3 INDIA SALES 30 INDIA PUR...

Hi DB2 Gurus, I have a situation where i have to use the subquery in the from clause. But db2 is failing to execute the query. Below query working fine in oracle but its failing in DB2 v9. Dont know if its a known issue. please advise. SELECT dim.code, fact.amt FROM dim INNER JOIN fact ON...

Hi Informatica gurus, Some one asked me a question like how can you pickup the source file name dynamically in the mapping with out using any unix scripting or paramfile etc. just using indirect file. Can someone answer me plz. Regards G

Hi Infa Gurus. I have a input value coming through I just want to know if the number is positive or negative. Is there any informatica function which finds it out whether a given number is positive or neg? or do i have to use the same old logic of converting the value into char and check the...

Hello DB2 Gurus, I need a favour. How can I handle exceptions in DB2, I am very new to the db2. I know about exception handling. but dont know how I can do it in db2. I want to drop the primary key on a table. I dont want to fail the stored_proc if the primary key doesnt not exist. Oracle...

Hi DWH Gurus, I know you have good suggessions for this topic, Please share with me. Please help me finding a good solution. I got a 24/7 Warehouse. As an ETL artect can you give me how we can handle delta load on this 24/7 used Warehouse. Regards G

Hi Unix Gurus, I got a file, that will have only one row. There is no carriage return for each row. Columnss are delimited by comma, rows are generated in fixed width except header. each row length is always 50 example. There is no delimiter between rows. [] characters in below exampler are...

Hi BO Gurus, I am working on BO XI r3.1. By default I chose to install the repository on MYSQL. Now i want to change it to Oracle. Is this possible? If how can i do this?. Please help me. Thanks G

Hi Oracle gurus. I got a situation where i wanted to know more about parallel hints. Please help me. Server Config: 4 * 1.5GHz UltraSPARC IV+ processors with 2MB on-chip L2 and 32MB L3 cache each, 8 banks of 2GB memory options (32 * 512MB DIMMs / 16B total for the board I got 4-dualcore...

Hello people, Please help me solving this as I am not expert in unix scripting. script: #!/bin/ksh v=$1 sed -e "s/PART_LIST=/PART_LIST=$v" myfile.txt output: sed: command garbled: s/PART_LIST=/PART_LIST=test Regards G

Hi Oracle gurus, I got the following query which is using the rank function and eating up my temporary tablespace and causing the query run very slow. DBS says its using lots of temp tablespace to sort the output. This table got 30m rows. Query: select col1, col2 from (select a.col1, a.col2...

Is list-list partitioning is alowed in 10g? I am trying to create the below table its giving an error like missing or invalid option. Am I missing anything? create table test_part ( bk_col varchar2(8), sid varchar2(4), current_record_flag varchar2(1) ) partition by range (SID)...

Pleasle suggest me the limit of distinct keys in a bitmap index. I have a big table 600 cols 30m rows. And I have a column with 200 distinct keys. Which index is recommanded on it? Your help is appreciated. Regards G

I have a table which is partitioned by group_code (that has 7 distinct values) All 7 partitions have nearly 4million rows. All partitions are on the same tablespace. When I am querying all the partitiones in parallel 7 queries. few 3 partititons throughput is above 500 p/sec and remaining...

Hi Oracle Gurus I have a big table with 125 columns and holds 100 million records. I like indexing one of the columns that is having 15,415 distinct keys. What index do you recommend on this column bitree or bitmap index. I guess bitmap is fine what do you say? Regards G

Hi I have a big table holding 1b rows. It is partitioned by a column contains 20 distinct values. Its taking 21 hrs to update one partition with 2m rows. I have a bitmap index on this table as well. I dont know why its taking that long?. I am guessing that bitmap index is not needed on...

Hi Oracle gurus. I need your suggessions on the below situation. I have a table with 200 columns, 60m records Columns KEY -- indexed C2 -- indexed C3 -- indexed C4 -- indexed C5 -- partitioned . . . . C200 DEL_FLG Update Statement: UPDATE TABLE SET DEL_FLG='Y' WHERE KEY=10000; I...