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 is the use of Surrogate Key in BO?
what is BIAR file in business objects xi r2
Explain how to execute the plsql procedure from the report by clicking with mouse?
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?
what are the complex reports you have created. Tell me with example?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
difference between xir2 and 6.5 version
What is thin client And thick client..?
working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.
1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data