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.

Answer / g.v.subramanyam

alias is logical popint to alternate to the table name.this
can be used to resolve the loops.

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.

Answer / vams_gk

alias is a logical table of existing look up table.using
alias we can resolve looops

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

what is BIAR file in business objects xi r2

3 Answers   TCS,

what is diff between Decode and case ? Give some Example?

2 Answers  

What is meant by multiple data provider.How to use it in universe as well as reporting environment?

6 Answers   TCS,

how many reports have u created ? explain a few.

1 Answers   InfoStep, Ness Technologies, TCS,

I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,

Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?

2 Answers  

what is isolated joins in check integrity

2 Answers   Accenture, Polaris,

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  

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

0 Answers  

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers  

what is traffic lighting in business objects?

1 Answers  

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

0 Answers