3.what is alias?
Answers were Sorted based on User's Feedback
Answer / nareshkumar
Aliases are references to existing tables in a schema. An
Alias is a table that is an exact duplicate of the original
table with a different name. The data in the table is
exactly the same as the original table. An alias breaks a
loop by using the same table twice in the same query for a
different purpose.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / g.v.subramanyam
alias is logical popint to alternate to the table name.this
can be used to resolve the loops.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / swades
An alias is a logical pointer to an alternate table name.
Exact copy of the original table.Establish a one-one join
between the original table and the table which is aliased.
The aggregatre results should be canned on to the aliased
table and not the original table.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / vams_gk
alias is a logical table of existing look up table.using
alias we can resolve looops
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / raga
one user prefrom different roles is called alias
eg
two dept are there sales , HR
user of sales working in HR with different row is called
alias
Is This Answer Correct ? | 0 Yes | 5 No |
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
5.what is slowly changing dimension ?
Explain what three things do you consider to be the most important factors for a manager?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
plz tell me about BOmain key in detail?
What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
what is diff between webi,deski,infoview
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
please anyone explain me the derived table with the problem tables.
I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?
There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?