how can we perform incremental aggregation?explain with
example?
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 are variable ports and list two situations when they can be used?
Define sessions in informatica etl?
Is it possible to create multiple domains on a single Informatica server?
Which is the t/r that builts only single cache memory?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What is workflow? What are the components of the workflow manager?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
without table how to come first record only in oracle?
Whats the difference between $, $$, $$$
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
can a port in expression transf be given the name DISTINCT