Interested to Buy Any Domain ? << Click Here >> for more details...
what is incremental aggregation ,with example?
- 2 Answers
- 9205 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 |
how do the project develops? pls specify right from the start to end in step by steps.
WAT IS TEXT LOAD?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How do you migrate data from one environment to another?
Two different admin users created for repository are ______ and_______
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
What are the out put files that the informatica server creates during the session running?
what is the need of session partitioning... how it is useful in real time
What is a unit Testing?
How do you remove duplicate records in informatica?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Teradata 
