Answer / sehaj

Incremental aggregation is nothing but a method of maintaing
new records in the target when we use an aggregator in our
mapping..
With incremental aggregation only those records which are
new in the source are processed in the mapping excluding
those which have been processed.
The data which was earlier present in the source n has been
processed is stored in the cache and the new records are
processed along with them.
For this we need to select the option INCREMENTAL
AGGREGATION from session properties.

Answer / naveen kumar

Before doing incremental aggregation u need to know incremental load, source data should be loaded incrementally, place a aggregator transformation group the ports on your requirement,like sales date then write your aggregate functions like max, min, sum, avg etc.. then check the property of incremental aggregation in session make sure the target table should have a primary key if it is relational then run the workflow... then u get the inital values pass a new record to the source and run the workflow.

What are some examples of informatica etl programs?

0 Answers  

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---

What is an aggregator transformation?

0 Answers  

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

Which will beter perform IIf or decode?

3 Answers   TCS,

---

Explain joiner transformation in informatica

0 Answers   Informatica,

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,

---