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.

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

What is a test load?

1 Answers  

---

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

How might you approve all mappings in the archive all the while?

0 Answers  

---

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---

daily how much amount of data send to production?

4 Answers   HSBC,

---

What is Session and Batches?

0 Answers   Informatica,

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---