Answer / eswar

When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes only incrementally and you
can capture changes, you can configure the session to
process only those changes. This allows the Informatica
Server to update your target incrementally, rather than
forcing it to process the entire source and recalculate the
same calculations each time you run the session.

Answer / sivaprasad

Gradually to synchronize the target data with source data,
there are further 2 techniques:-
Refresh load - Where the existing data is truncated and
reloaded completely.
Incremental - Where delta or difference between target and
source data is dumped at regular intervals. Timsetamp for
previous delta load has to be maintained.

Answer / bharat

Incremental aggregation is a technique by which we can
capture the aggregated data incrementally.
for this we have to sort the data before sending it to
aggregator then we have to enable the property incremental
aggregation in the workflow level inside the session.

Answer / rams

using incrimental aggrigation in session level,we calculate the only capture changes data in source,This allows the Informatica Server to update your target incrementally..

Answer / ankit kansal

Incremental Aggregation ->

Incremental Aggregation is a technique to populate data on your aggregated tables or materialized view incrementally.

It takes new incoming data only based upon last updated column value or created_date time stamp column and thus uses its own cache created/updated earlier and updated the table as required.

http://deepinopensource.blogspot.in/

Answer / vas chiky

If suppose, i use a dynamic lookup of target agg table and
an update stategy to update or insert records.. what is the
difference between this and Incremental aggregation ?? why
i need to depend on this Incremental aggregation chk box??

please clear my doubt

Answer / siva

If we choose Incremental Aggregation Informatica will store the cache files permanently.

Answer / raghvendra

incremental aggregation performs aggregation on incremented
data..so based on requirements if we can use incremental
aggregation then definately it will improve performance..so
while develop mapping always keep in mind this factor too...

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

In session log thier should not be a single error how will u do

3 Answers   HCL,

how to load rows into fact table in data warehouse

0 Answers   Informatica,

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

What is polling in informatica ?

1 Answers   TCS,

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

EXL informatica Questions

0 Answers  

What are ETL Tools?

0 Answers   Informatica,