Answer / nagaraju bhatraju

Aggregate awareness can be used in following situations
1) you have summarized tables and detail tables and you
want BO to pick up right table based on what kind of object
you have pulled in your query.It helps to associate right
objects automatically and hence enhance your BO report
performance
2) Also, can be used if someone wats to setup complex logic
to pickup certain tables only, when picking certain columns
from one table.This can be done be setting up incompatible
objects in aggregate awareness panel.


Um....we could go many places with that, but here's my stab
at it. In
BusinessObjects it is the ability to, using the measure
objects, dynamically
interpret the context of the dimension objects and to "add
together" the
values of the measures involved. They call it "semantic
dynamism". For
instance, if I have a report listing 30 people, with their
name, gender and
their age (expressed as a measure object) each row of data
will show each
person's age. If I remove the name object from the table,
leaving only the
gender and age objects, BusinessObjects is "aware" that the
context of the
calculation has changed and that the only defining object
is gender.
Clearly, we should only have two genders (at least we hope,
right?) so the
age measure AGGREGATES to fit the new context, so you see
the average age
for each gender instead of individual ages of each person
(because the name
object was removed the rows are no longer defined by that
object). Does
that help explain the concept?
My definition of "Aggregate awareness" for a BI/Query tool
would be:
- the tool would automatically pick the right (i.e. highest
level/more aggregated) table based on the level of the
query requested.

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

---

Without source how to insert record to target?

6 Answers  

---

what is degenerated dimension

6 Answers   Cap Gemini,

---

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,

---

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---