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 |
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
Without source how to insert record to target?
How to eliminate duplicates in FF and oracle both
How to get EVEN & ODD numbers separately?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
What is tracing level and what are the types of tracing level?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
create a mapping to retrieve the employees who are getting salary greater than average salary?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
wf dont have integration severances how you can run?