how can we perform incremental aggregation?explain with
example?
- 9 Answers
- 21465 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 |
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
What is polling?
Filter transformation in the condition one of the data is NULL would the record be dropped.
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
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.
Can we create multiple integration service on single repository?
Describe data concatenation?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
What are the different options available for update strategy?
What does update strategy mean, and what are the different option of it?
Teradata 
