Search results for query: *

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.

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

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

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

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

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

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

Hi, I have a front-end application that inserts a record in a table. There is an insert-update trigger on that table(table2) that calls a pl-sql. there is a piece of select statement in the plsql block. ********* select col1, col2, col3 into var1, var2, var3 from table1 where cond1 *********...

Is there any institution that provides certification in Datawarehousing technology. Would be interested in knowing of any such ones. thanks in advance.

I am trying to configure the MSTR Web by adding an Intelligence server. When I try to mention the server name and click on ADD, it gives me an error "M8DSDML.dll not registered properly. Please contact administrator". I do not see the new IS added. The same Win2K server has both the MSTR...

Hi, I require an extract that gives me all the attributes, their ID, DESC definitions, and atleast the lookup source table. Is there a better way to get this extract other than manually editing each attibute and noting down the details. Can we use Command Manager for the same. Please respond...

Hi, I am analysing MSTR 7.5. Created a small projetc with 3 attributes and fact and a metric (sum) defined over it. I used the attrbutes and the metric in a report. the SQL of the report does not have the group by clause. Neither does it Sum the fact column. Am I missing any configuration or...

Hi, I have a SQL that runs into 2 passes. In the first pass I have to get the MAX(MILES) group by a vehicle. In the second pass I get the Sum of the Max miles in a company. So the 2nd SQL should actually should just have the PASS 1 temp table in the FROM clause. But what I see is that a couple...

Hello, Can anyone guide me to some best practises followed while working in the MicroStrategy environment. Could be in the form of some useful tips and dos-donts. Thanks.

I am running Narrowcaster 7.2.1. The application that I am working generates emails based on the user email address (and the security lying underneath in Oracle DB) to produce excel attachments. Settings: Segment size = 100 Total emails sent = ~2500 Size of emails = 30KB - 8MB Of late, I have...