Interested to Buy Any Domain ? << Click Here >> for more details...
how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 23562 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / archie
Hi Deepak,
spelling of grammar is grammar not grammer.
:-)
| Is This Answer Correct ? | 14 Yes | 0 No |
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 |
Answer / suneelkumar.dasari
U DEEPAK, if u r perfect in english start one english institute.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / xyz
With your perfect grammEr the English institute will be a
big failure
| Is This Answer Correct ? | 7 Yes | 0 No |
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 |
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 |
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 |
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Enlist the advantages of informatica.
Can you access a repository created in previous version of Informatica?
When the informatica server marks that a batch is failed?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
Briefly define a session task?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the tasks that Loadmanger process will do?
What are the types of error logs available in Informatica?
How can i set break points in debugging mode ? can explain steps please?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Teradata 
