Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

can we create aliases for every table beforehand? if yes
whar are the disadvantages?

Answer Posted / satishe

u can create alias for very table but its better not create
alias for fact tables.If unnecassarily alias are created
for evey table the universe structure will be complex.so
more number of tables will be present in your schema.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1918


How were the reports scheduled and how to resolve unexecuted documents?

2724


Can we configure two instances of CMS pointing to two different CMS system databases?

2083


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1892


What is report template in b.o?

1074


What is difference between webi and infoview?

1325


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2096


Explain what is the difference between slice and dice and cross tab report?

1135


What would you consider as your biggest achievement and why?

1059


What task is 98% of the required work of a business analyst?

1115


Explain when we use aggregate awareness function in designer?

1088


What sort of existing documents should business analysts refer to when starting on a new project?

1059


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2471


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2329


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1070