Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is incremental aggregation ,with example?

Answer Posted / 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.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2120


What are mapplets? How is it different from a Reusable Transformation?

1132


Enlist few areas or real-time situations where informatica is required.

1137


What is joiner transformation?

1062


What are the databases that informatica can connect to windows?

1095


Sequence generator, when you move from develoment to production how will you reset

2119


Explain constraint based loading in informatica

1142


What is a node in Informatica?

1083


Separate from an archive server and a powerhouse?

1005


what is SDLC way of code development?

2089


What are the new features of informatica 9.x at the developer level?

1102


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

1079


How you know when to use a static cache and dynamic cache in lookup transformation?

1913


What is a filter transformation?

1084


How to call shell scripts from informatica?

1042