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.

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

How many transformations can be used in mapplets.

0 Answers  

---

daily how much amount of data send to production?

4 Answers   HSBC,

---

why we use stored procedure transformation?

4 Answers   IBM,

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

What is a candidate key?

7 Answers   CTS,

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

---

generate Unique sequence numbers for each partition in session with Unconnected Lookup ? Hi All, Please help me to resolve the below issue while Applying partitioning concept to my Session. This is a very simple mapping with Source, Lookup , router, and target. I need to Lookup on the target and compare with the source data, if any piece of data is new then Insert, and If any thing change in the existed data then Update. while Inserting the new records to the target table I'm generating sequence numbers with Unconnected lookup, by calling the maximum PK ID from the target table. The above flow is working fine from last one year. Now I wish to apply the Partitioning concept to the above floe(session) At source I used 4 pass through partitions.(For Each partition different filter conditions to pull the data from source) at Target I used 4 passthrough Partitions. it is working fine for some data, but for some rows for Insert Operation , it is throwing Unique key errors, because while Inserting the data it is generating the same sequence key twice. In detail : 1st row is coming from 1st partition and generated the sequence number 1 for that row. 2nd row is coming from 1st partition and generated the sequence number 2 for that row 3rd row is coming from the 2nd partition generated the sequence number 2 again for that row. (it must generate 3 for this row) the issue is becuase of generating the same sequence numbers twice for different partitions. Can any one Please help me to resolve this issue. While Applying partitions how can I generate a Unique Sequence numbers from Unconnected lookup for Each partitioned data. Regrads, N Kiran.

2 Answers   Tech Mahindra,

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

what is target update override and when we use it?

2 Answers   TCS,

---