Interested to Buy Any Domain ? << Click Here >> for more details...
what is incremental aggregation ,with example?
- 2 Answers
- 9163 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the Hierarchy of DWH?
How is union transformation utilized?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
what is fact table?
how to get max value record into one target and remaining records into another target?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
If informatica has its scheduler why using third party scheduler?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
How do you load first and last records into target table?
Teradata 
