Question { 8008 }

what is incremental aggregation ,with example?

Answer

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.

Question { TCS, 8386 }

How are parameters defined in informatica?

Answer

parameters are defined in a mapping parameter/variables wizard.we can pass the values to the parameter outside the mapping without disturbing the design of mapping,but parameters are constant,until and unless user changes