how can we perform incremental aggregation?explain with
example?

Answers were Sorted based on User's Feedback



how can we perform incremental aggregation?explain with example?..

Answer / friend

He explained in Practical manner, so if your strong in
technical you can understand otherwise ..... and plz don't
discourage others

Is This Answer Correct ?    18 Yes 0 No

how can we perform incremental aggregation?explain with example?..

Answer / archie

Hi Deepak,

spelling of grammar is grammar not grammer.

:-)

Is This Answer Correct ?    14 Yes 0 No

how can we perform incremental aggregation?explain with example?..

Answer / jose albin

Hi

Anyway u got the right answer, ok
Please don't irritate other people

Is This Answer Correct ?    15 Yes 2 No

how can we perform incremental aggregation?explain with example?..

Answer / suneelkumar.dasari

U DEEPAK, if u r perfect in english start one english institute.

Is This Answer Correct ?    7 Yes 0 No

how can we perform incremental aggregation?explain with example?..

Answer / xyz

With your perfect grammEr the English institute will be a
big failure

Is This Answer Correct ?    7 Yes 0 No

how can we perform incremental aggregation?explain with example?..

Answer / srinu

You have to perform the Incremental Aggregation in Session
Properties only.
Ex:-
You Target Table loaded(with Agg Caluclation) 100 Records
on yesterday ,
Now newly you have 50 Records(25 update,25 insert),
To done the Agg calculation for Updated Records ,Insert
Records you need to
Perform Incremental Aggregation.This is simple way to
increase the Performance,
Redusing the time etc.
If you not perform the Incremental Aggregation, you can
do the same thing
In another way.But it’s lenthy.
Any ??? or Corrections,,let me
know ‘Srinu.srinuvas@gmail.com ‘

Is This Answer Correct ?    12 Yes 9 No

how can we perform incremental aggregation?explain with example?..

Answer / appireddy

Its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.

Is This Answer Correct ?    2 Yes 0 No

how can we perform incremental aggregation?explain with example?..

Answer / ravi

Well said Archie.. ))

Is This Answer Correct ?    0 Yes 0 No

how can we perform incremental aggregation?explain with example?..

Answer / deepak

I wish people answering in this forum use correct English.
Many sentences are confusing at first glance due to poor
grammer.

Is This Answer Correct ?    8 Yes 20 No

Post New Answer

More Informatica Interview Questions

What does update strategy mean, and what are the different option of it?

0 Answers  


What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,


Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  


What is workflow manager?

0 Answers  


I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,


why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,


what is normalizer transformation?

4 Answers   Wipro,


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


How does a sorter cache works?

0 Answers  


Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,


What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,


Categories