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

How to convert multiple rows to single row (multiple columns) in informatica

1376


Explain about Informatica server process that how it works relates to mapping variables?

1070


Explain the types of transformations?

1061


What is meant by pre and post session shell command?

1152


What is the function of union transformation?

1126


In which transformation you cannot drag ports into it?

1315


What is meant by a domain?

1122


How do you handle two sessions in Informatica

1153


Explain lookup transformation is active in informatica

1090


In development project what is the process to follow for an etl developer from day1

1719


State the differences between sql override and lookup override?

1198


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2161


What is the different lookup cache(s)?

1082


Do you find any difficulty while working with flat files as source and target?

1093


Tell me about Propagate functions in informatica

919