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

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

0 Answers

What is aggregate table and aggregate fact table ... Any examples of both?

0 Answers

Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 Answers

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

4 Answers TCS,

From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?

1 Answers

what is main functional differences between BO and COGNOs?

5 Answers TCS,

Tell me the difference between cmc and cms?

4 Answers Wipro,

my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers

what is the difference between Ranking and sort-out in bo?

2 Answers iNautix, TCS,

what are the complex reports you have created. Tell me with example?

7 Answers Insurance, TCS,

WHAT IS INPUT CONTROL IN BO?

3 Answers PWC,

Explain the SQL Queries activated to data base from Data provider in BO ?

1 Answers Polaris,

For more Business Objects Interview Questions Click Here