Interested to Buy Any Domain ? << Click Here >> for more details...
how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 23903 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 |
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
Can you use one mapping to populate two tables in different schemas
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Why do you use Mapping Parameter and mapping variable?
What is the difference between IN and Exists in Oracle?
what is confirmed fact?
Performance wise which is better joiner or look up ? Give me with example?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Teradata 
