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!

Search results for query: *

  1. yaffle

    QUEST

    ...it is TOAD your vendor refers to, the acronym stands for Tool for Oracle Application Developers and it provides a MS-Access-like alternative to SQL*Plus for interaction with an Oracle database. Beware when using with a production database however, as it has a tendency to lock tables being...
  2. yaffle

    How do I return a sorted top ten list?

    You could try something along the lines of: select e.* from employee e, (select e1.emp_id, count(e2.emp_id) from employee e1, employee e2 where e1.startdate < e2.startdate (+) group by e1.emp_id having count(e2.emp_id) < 10) sub where e.time_key =...
  3. yaffle

    Subquery in INSERT Statement

    If your source and target tables are in the same database instance, instead of using a values clause you should be able to do something like: insert into target_tab (col_a, col_b, col_c) select a, b, c from source_tab; I'm not familiar with JD Edwards, so this syntax may not be exactly correct...
  4. yaffle

    TIME FUNCTIONS IN SQL

    You could do it with a PL/SQL script e.g. DECLARE l_date date; BEGIN FOR c_duration IN (select time_opened, time_closed from duration) LOOP l_date := to_date(to_char(c_duration.time_opened,'YYYYMMDDHH24MI'), 'YYYYMMDDHH24MI'); LOOP...
  5. yaffle

    PowerCenter Platforms and Performance

    geenew, a small proof of concept at my site with PowerCentre 5.1 using a 4 CPU NT box with 1Gb RAM showed high paging and disk usage - it was concluded that considerably more RAM may be needed as it is planned to run many streams in parallel. Did you specifically choose an IBM M80 for the job...
  6. yaffle

    store pictures in Oracle and access it thru Visual Basic Help

    Have a look in the Oracle8i Application Developer's Guide - Large Objects (LOBs): You could use Oracle Objects for OLE (OO4O), a Windows-based product included with Oracle8i Client for Windows NT. You can make changes to a LOB via OO4O by using one of the following objects interfaces...
  7. yaffle

    Is TIME a SCD or FCD?

    I don't see any need for slamming - in fact I'd agree with you :-) The time dimension may grow when keys for new days / weeks / etc. are added, but once in there, a time dimension element doesn't change its values unless you restructure the dimension (e.g. to add quarterly reporting if not...
  8. yaffle

    duplicated records

    Limona, This post would probably better fit in the Oracle Developer forum ( http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/31/pid/259 ), but you may be able to process the records in your second block individually, looping around each in order to trap duplicate row errors (and possibly...
  9. yaffle

    Fetching Data based on the day

    Soheils, you could try converting DateShown to a text string and comparing the last so many characters with the equivalent from today's date.
  10. yaffle

    Hardware for ETL

    I'd like to canvass your opinion and experience regarding what server hardware has been used to run ETL products. I'm particularly interested in hub and spoke tools here (e.g. Informatica PowerCenter, Ascential DataStage, etc.) rather than code-generators (e.g. ETI Extract), or set-ups where the...
  11. yaffle

    math function

    Boa, if the groups are regular groups of 5 you could try grouping by something like trunc(x/5) i.e. the integer result of a division operation (n.b. syntax may vary depending on RDBMS); if not you may want a look up table with lower and upper range bounds and an identifier, join to it where...
  12. yaffle

    PowerCenter Platforms and Performance

    I have a general question regarding what platforms people are running Informatica on out there, and what sort of performance they are experiencing. I'd be interested in the vendor, operating system, amount of processors and RAM, and the amount / type of data being transformed.
  13. yaffle

    Query for available time

    I sounds like you're going to try selecting things that aren't there - always tricky ;-) I'd suggest using a second temporary table, populating it with the possible slots, in one hour increments or whatever granularity is required, then select slots from this secondary table where timestamps...
  14. yaffle

    Controlling Snapshot Refreshes

    The idea behind the query rewrite feature is that you define your MV to match a commonly executed query on a (set of) large tables; then instead of having to select from your snapshot explicitly by re-writing your query code, the RDBMS will detect the conditions of your query and determine that...
  15. yaffle

    Start doing datawarehousing

    Data Warehousing technology covers a wide range of products, tools and techniques. Probably more important than any of them though is to have a good understanding of why you're considering it, and what information is highest priority. As anand4all implies, unless your organisation has a lot of...
  16. yaffle

    Monitoring Tuxedo

    The Tuxedo version number displays when you boot up the Tuxedo servers using tmboot; alternatively, it is written at the start of the ULOG files when a new file is started. Tuxedo includes some functionality for restarting servers when errors are detected; the times I've seen them die have been...
  17. yaffle

    Multi Level Dimension

    I would suggest that you model the hierarchies to correctly reflect the business relationships. What you will have to consider with this sort of 'uneven' data, is how you structure your information. One option may be to generate 'dummy' key entries to represent aggregations/unavailability of...
  18. yaffle

    How to control the duplicate primary key!!

    Serji, Are you trying to implement a trigger to stop duplicate rows from being inserted ? or to handle the error caused an existing constraint ? If the former, then the (Oracle 8i) syntax for adding a primary key contraint is shown below, if the latter, you may be better putting a trap...
  19. yaffle

    PL/SQL:how to transform a string in an executable sql statment?

    Oops, typing too slow, you got in before me Mike. I was assuming the problem was dynamically executing the statement stored in the table row ?
  20. yaffle

    PL/SQL:how to transform a string in an executable sql statment?

    This sort of construct may work for other forms of DML statement (e.g. inserts), but it won't work for selects. Select statements return a result set (the column values), but you haven't provided anywhere for your results to be put.

Part and Inventory Search

Back
Top