Search results for query: *

Hi , I have new requirements with me here which shows around 300 tables in a 10G database that have to go into a warehouse (another 10G DB to be designed). All ETL will be done by informatica since the databases are geographically separated and each one cannot access the other. Now i want to...

Folks, i am back with a problem. :) We have an OWB mapping that is configured to do ETL operations on a large amount of data. When we tested this in our development environment ( which had around 50000 rows), it ran just fine - in production though, since we have around 500000-600000 rows(10...

Folks, i am back with a problem. :) We have an OWB mapping that is configured to do ETL operations on a large amount of data. When we tested this in our development environment ( which had around 50000 rows), it ran just fine - in production though, since we have around 500000-600000 rows(10...

Hi, Which sys table/view contains the information on when an SP was compiled? (Question-1) Last_DDL_Time in All_Objects seems to be the answer, but even on compiling my SP , the time didnt appear to change in this table -- Is this table updated only on every analyze, right? (Question 2) If...

Here is the situation i am in:- I have to generate a random 6 digit number. Sounds simple. SELECT ROUND(DBMS_RANDOM.VALUE(100000,999999)) NUM FROM DUAL; Ah! here are the couple of catches:- 1) This number should not be a previously generated number ( stored in a difft table, called table X)...

Ok , here is the situation:- I have a set of records in a table , say table OLD_DELIVERIES (this contains all the houses to which we have delivered flowers in the past) House# Lat Long H1 17.15000000 -61.81666667 Row_1 H2 37.85000000 144.75000000...

I have a small batch file that runs a query when the user invokes it. This batch file contains sqlplus commands and spools the results of the query into a file called "data.csv". The colsep is set to ',' and so i have a neat little excel-like report for this special user. Now the problem is...

Hi , i am new to informatica. So new that an emu running wild is more informatica-wise than me on my best day. Just got access to informatica, and in Informatica PowerCenter Workflow Manager (i have informatica powercenter 6.1), i can see a list of workflows developed by our team. Have...

Hi, I have encountered this situation a million times as a DBA... there are migration queries that seem to take forever to complete because of the huge volumes of data involved. After 4 migrations under my belt , i am working on the 5th Migration now...and have this question --> in Oracle...

Ok , Here is the sticky situation :- consider table FLOWERS. FLWRID FLWRLGCYID FLWRTYP FLWRNM LNGTH WDTH SLSIND 1 101 Stemmed Rose 10" 2" 1 2 102 Stemmed Rose 20" 3" 3...

Hi , i had exactly the same problem in Oracle a few weeks ago. I struggled with it and found the solution in ROW_NUMBER. Oracle being my stronger field , i was able to get a solution. Unfortunately , i have exactly the same problem in MSSQL and i have no clue how to solve it. Moreover , the...

Hi , Suppose there is a table 'FLOWER_SALE' like this :- Flower Year Month Numbers_Sold ------------------------------------ Rose 2004 12 1000 Lily 2004 02 500 Rose 2004 11 900 Rose 2004 10 890 Iris 2004 01 200 Lily 2004...

Hi ! Here i am again. From the past few weeks , the DBA team who monitor our production database have been on my back regarding the ORA-1000 error. They say that there are a few sessions that have more than 999 cursors open. While i didnt take much notice of it , i was alarmed to see that...

I have a varchar2 field that has data like '100000 out of 400000' , '100 out of 100000' etc. Now i have to format it as '1,00,000 out of 4,00,000' '100 out of 1,00,000' etc. Actually , i am myself creating this text field : ie i have 2 numeric variables that are concatenated with 'out of' to...

Hi , Here is one of my famous requirements again . Table : Flowers FL_ID NAME PRICE 1 Chrysanthemum 1.09 2 Catstail 1.32 3 RedRoses 6.12 Table : Orders O_ID FL_ID 101 1 101 3 201 2 301 3 401 1 401 2 401 3 And...

Hi , I have a varchar2 column in a table of mine. Here is an example : Tablename : Flowers ID------NAME-----------------PRICE 1-------Chrysanthemum-----------1.09 2-------Catstail---------------------1.32 3-------RedRoses-------------------6.12 4-------Pinkie's Roses--------------3.67...

Hi , I have a table that has text like : Code Order_Reasons ----------------------------- PrimRose 1-2, 3-2, 12-5 Henna NULL Basil 2-12,3-19,3-23,5-50,5-51 I have to put this data in another table as : Code Order_Reasons ----------------------------- PrimRose 1-2...

Hello , I have a table say "Coffee_Mapping" , and it has the foll 2 columns apart from others: C_Bean_Id, Coffee_Type I have 4 Types of Coffee : Cappuchino , Espresso , Mocha and Boring. There are some beans that can be used for all types of coffee, and some beans that can be used only for...

Hi, This is quite a verbose post and i apologise....the problem is very simple(stated by the subject), but i am mentioning it in an example so that we can be clear of what i am talking abt..... I Have 3 Tables called Initial_Input (App_Key NUMBER NOT NULL,Status CHAR(1) NULL,Paper_Key NUMBER...

Hi , Is it possible to convert an existing normal table to become an IOT ? ALTER TABLE X ORGANIZATION INDEX; doesnt seem to work... Regards, S. Jayaram Uparna . :-)