By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.

raju

• Jan 23rd, 2007

we can do this by cartesian productno condition to be here in querryselect e.name,e.idfrom emp e, emp p

Answer Question  Select Best Answer

shivaleela

• Jan 30th, 2007

i thk it requires 14 joiner,bcoz as per d rule 4 N table to joine v required (N-1) joins

Answer Question  Select Best Answer

Mohit Sethi

• Jan 31st, 2007

Data Pool basically explains key terminologies involved and how data are grouped into "messages", and the different classes or subclasses and "levels" within this organization.

Answer Question  Select Best Answer

An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• Feb 3rd, 2007

Lists of Values (LOVs) enable end users to choose entry field values in a form or database portlet customization form.

E.gomathi

• Feb 7th, 2006

LOV is list of values, used to popup the single or multiple values at run time

Answer Question  Select Best Answer

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

there is a concept called dependencies .please check in oracle websiteif tables is altered then view becomes invalid...............but some conditions it is not invalid for example create table table1...

ravitala

• Jul 18th, 2006

NO, the view do not get refreshed when you update a data base table immediately.We have to recompile, to get them refreshed.There are 2 methods to get that refreshed .Method One:Manual approach:-ALTER VIEW COMPILEMethod Two:Automatic approach:-Select * from

Answer Question  Select Best Answer

Sandhya Rani

• Feb 16th, 2007

Hi Satish,Instead of creating a object what you mentioned above(x/y)*100., better to create an variable so that it will solve the problem as for as my knowledge goes.lets say1, object (x)2, object (y)create a varible naming (% of x & y)you will get the proper report.Thanks & RegardsCheers,Sandhya

Answer Question  Select Best Answer

I have read somewhere as DDL statement as it has implicit commit statement.

Chiranjeevi Manne

• Mar 30th, 2007

TRUNCATE is a DDL statement which can't be rolled back as there won't be any redolog generated during the trun operation and it is the fastest way of dropping big tables avoiding tons and tons of redolog generation.

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

Other point it will not fire any trigers so it is fast .and it releases the storage space also. where delete command slower than truncate command fires triggers

Answer Question  Select Best Answer

Chiranjeevi Manne

• Mar 30th, 2007

Using OPATCH Utility

Answer Question  Select Best Answer

Chiranjeevi Manne

• Mar 30th, 2007

You can store the images in oracle database as BLOBS (Binary Large OBjetcS).

Priya

• Oct 15th, 2006

S, u can upload the image in data base,by taking datatype as Image.

Answer Question  Select Best Answer

Chiranjeevi Manne

• Mar 30th, 2007

Infact your question is not straight forward,but anyhow if you are routing the transactions to the newly created database on another server then you can export the pending data and import into new dat...

Answer Question  Select Best Answer

Laxmi Prasad

• Apr 2nd, 2007

U can call that data using database name.tablename.fields

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

since the data is in two different tables you have two different choices, JOIN or UNION.  In this case you would probably use UNION. However you can make it much simpler by just leaving the data ...

Answer Question  Select Best Answer

visitor

• Apr 13th, 2007

Normalization is a process to reduce  the redundancy in databases.meaning finding a way to represent a particular data in such a way that  with least representation also it can be accessed in all the ways possible. There are a few ways of doing it like 1nf 2nf 3nf bcnf etc..

lance cheng

• May 22nd, 2006

It adds data integrity

Answer Question  Select Best Answer

RyanJames

 Profile Answers by RyanJames Questions by RyanJames

• May 8th, 2007

Virtual warehouse is a important terminology of E-Commerce technology. The main advantage of virtual warehouse is reduction of costs and the flexibility of handling to users. This is because the avail...

Answer Question  Select Best Answer

Srinivas Ellendula

 Profile Answers by Srinivas Ellendula Questions by Srinivas Ellendula

• May 13th, 2007

Check is there any high CPU using , u can find the infomartion by using below commands in SOLARIES/AIX servers.nmonsudo topasvmstat 1 10sar 1 10topRegardsSrinivas Ellendula

Srinivas Ellendula

 Profile Answers by Srinivas Ellendula Questions by Srinivas Ellendula

• May 13th, 2007

First  of all check the process running on that server...if the idle process is 0, look  if there are any run away processes taking most of the CPU and find exactly what it is doing... ...

Answer Question  Select Best Answer

Find_timercreate_timerdelete_timer

shiraaz

• Jul 13th, 2007

There are three builtins asociated with timercreate_timer set_timerdelete_timer

Answer Question  Select Best Answer

aju_mech

 Profile Answers by aju_mech Questions by aju_mech

• Jul 25th, 2007

Prompts in MicroStrategy are used for Manipulating data in report while executing it. For Ex. If there is a report with attribute region and Profit Metrics and having a prompt on region attr...

S

• Oct 25th, 2006

A prompt is a MicroStrategy object that allows userinteraction at report run time. The user is asked during the report execution to provide an answer tocomplete the information.Uses:Prompts are useful...

Answer Question  Select Best Answer

A  property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on  it.  An  object  based  on  a  property  can inherit the setting of any property in the clause that makes sense for that object.

fastfreeeasy

 Profile Answers by fastfreeeasy Questions by fastfreeeasy

• Jul 26th, 2007

If you are talking about Developer/2000 then this is not Property Clause rather Property Class. One more thing is that change of visual attribute of an item is possible programatically but the same is...

Answer Question  Select Best Answer

padmanabham

• Jul 28th, 2007

Non primary column direclty depended on the primarykey column is called a 3rd narmalization form

rajesh

• Oct 17th, 2005

In order to be in Third Normal Form, a relation must first fulfill the requirements to be in Second Normal Form. Additionally, all attributes that are not dependent upon the primary key must be eliminated.

Answer Question  Select Best Answer

sanjeev

• Aug 6th, 2007

In session properties we have the target commit interval. There we need to mention the commit interval as 1000.Sanjeev

Rajesh

• Oct 10th, 2006

Yes, we have different logic to accomplish this thing in Informatica. You use either sequence generator and Filter transformation or Expresion and Fileter transformation. If you are sorting and loadin...

Answer Question  Select Best Answer

Rajesh S

• Aug 10th, 2007

This option provides a high level of integrity (WRITE inegrity) for data being updated, while providing no special protection for data only being read. Many tasks in several VSE images can open the ...

Answer Question  Select Best Answer