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

Categories >> Software >> Data Warehouse >> Business Objects
Suggest New Category

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

Question Posted / sasikanth

5 Answers
10565 Views
AG Technologies, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / saranv

In the Designer you can create allias for the table. U had that option in menu
bar.You just select the table and type the alias name. This is used to avoid some
looping and trap problem.

Other than Complex univese structure i dont no about the disadvantage

Is This Answer Correct ?

2 Yes

0 No

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

Answer / 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

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

Answer / kiran

There are no any disadvantages for creating aliases..it is
good practice in the projects to create aliases for all the
original db tables and create joins between them, rather
than using original db tables..when we do intigrity check
on this universe it throws all the errors that those
original tables have no joins ...this is the only problem
what I see, by creating aliases..

other then that aliases are used to resolve loops and traps.

Is This Answer Correct ?

2 Yes

1 No

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

Answer / mahesh225

We cannot create alias for all tables.
Because alias will make extra table and extra join .This is one of the disadvantage .

For confirmed dimentions we cannot create a alias.

www.futuresoftworld.com

Thanks

Is This Answer Correct ?

0 Yes

0 No

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

Answer / swati

What are the different datamodelling techniques?

Is This Answer Correct ?

0 Yes

4 No

Post New Answer

More Business Objects Interview Questions

what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash

2 Answers

What is self join

2 Answers Blue Star, IBM,

What is the pivot option ? what is the need of it?

1 Answers Infotech,

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

0 Answers

GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?

1 Answers

what is Scope of Analysis

8 Answers TCS,

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

4 Answers

how to create dashboard reports

4 Answers TCS,

What is Indexing? how did u implement indexing?

0 Answers TCS,

What is the server based ranking? and its usage?