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 datamart

  1. datamart

    Display results in Columns

    Hi, One of my friends was able to get this through in case of a fixed set of rows.. Here is the way you can do it. create table temp_trans( col1 varchar2(10) ) Suppose you insert 3 rows in the table--- then, select max(decode(rownum, 1, col1, null)), max(decode(rownum, 2, col1...
  2. datamart

    Display results in Columns

    Santa, Your questions are valid. But basically, there is no business requirement to achieve this. My friend was asked this question in an interview and we were wondering if this is possible. Assume that the table is a restricted one with finite number of rows - we can assume it to be 10. Since...
  3. datamart

    Display results in Columns

    I am sorry to have missed an important point here. I cannot use a pl/sql. Instead I should be using normal SQL. Is it still possible?
  4. datamart

    Display results in Columns

    Suppose I have a table with only one column. When I query the table SELECT COL1 FROM TABLE1; This gives me the result COL1 ------- VAL1 VAL2 VAL3 VAL4 ... But my requirement is to have the display in the format VAL1 VAL2 VAL3 VAL4 ... Is there a way to achieve the above? Regards.
  5. datamart

    Sort Metric by Dynamic Dates

    Have you tried using the Metric Dimensionality feature. You can set the Grouping to User. This should help you obtain the results.
  6. datamart

    Oracle Character Set.

    yes.. this system only deals with European countries and their data. So can I be positive and use 8859-1 many thanks.
  7. datamart

    Oracle Character Set.

    Need to get some information related to Character set UTF-8 and ISO-8859-1 Version 9i Currently when we implemented UTF-8, every special character occupied an additional byte. This means that we need to possibly double the field length in the oracle table. To avoid this, can we implement...
  8. datamart

    Automatic Index Analyze

    Hi All, I am using Informatica for my ETL processes. I have a couple of fact tables and 5 aggregate tables. After my daily load, I would like to analyze all the indexes in the fact and aggregate tables. Is there a way by which I can dynamically analyze the indexes of a particular table after...
  9. datamart

    View question

    Hi, I currently have a summary table that is created in a very complex manner. This summary table consists of data for each and every user and his security access. The front end queries this table with filter conditions such as userid, and other components. This table is running into a lot of...
  10. datamart

    Lookup on Master table

    Thank you very much maswein and mufasa... I was able to come out with a different solution for the same. I used flags in the master table that indicates inclusion or exclusion. Depending on the flags I use Case statements for joining the columns correspondingly. Actually, I wanted to solve this...
  11. datamart

    Lookup on Master table

    HI.. there is no fixed list. what i gave was just an example.. all the 3 columns could be like the one i explained.. thats the reason why i have trouble finding a solution.
  12. datamart

    Lookup on Master table

    I have a master table with following columns Table1 ----------- Code Type LookupValue Code and Type columns are primary keys. The sample data for this table will look like this Code Type LookupValue ------------------------------------------------------- A all 1 B exclude X 2 C...
  13. datamart

    Lookup on Master table

    I have a master table with following columns Table1 ----------- Code Type LookupValue Code and Type columns are primary keys. The sample data for this table will look like this Code Type LookupValue ------------------------------------------------------- A all 1 B exclude X 2 C...
  14. datamart

    Filter Element Search

    When you login into desktop, do you login as that same user or as an Administrator. So would this issue relate to any Security Filter (on that attribute). The other possibility could be element cache. You could delete all the Cache objects for that project and then try listing the elements.
  15. datamart

    Invalid Packages..

    Hi.. I have a number of packages. A few of them are invalid. I use Embarcadero RapidSQL as a tool for querying purposes. The problem is that when I try to validate the packages by recompiling them using the click options of the tool, one or more other packages automatically gets invalid. I am...
See more

Part and Inventory Search

Back
Top