Interested to Buy Any Domain ? << Click Here >> for more details...
Define Incremental Aggregation?
- 2 Answers
- 6879 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhinaw prakash
When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes incrementally and you can
capture changes, you can configure the session to process
those changes. This allows the Integration Service to update
the target incrementally, rather than forcing it to process
the entire source and recalculate the same data each time
you run the session.
For example, you might have a session using a source that
receives new data every day. You can capture those
incremental changes because you have added a filter
condition to the mapping that removes pre-existing data from
the flow of data. You then enable incremental aggregation.
When the session runs with incremental aggregation enabled
for the first time on March 1, you use the entire source.
This allows the Integration Service to read and store the
necessary aggregate data. On March 2, when you run the
session again, you filter out all the records except those
time-stamped March 2. The Integration Service then processes
the new data and updates the target accordingly.
| Is This Answer Correct ? | 8 Yes | 0 No |
IF THE SOURCE CHANGES ONLY INCREMENTLY AND U CAN CAPTURE THOSE CHANGES
YOU CAN CONFIGURE THE SESSION TO PROCESS ONLY THOSE CHANGES
| Is This Answer Correct ? | 2 Yes | 0 No |
what is datamart
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
When you move from devel to prod how will you retain a variable
What is lookup change?
What is the default source option for update stratgey transformation?
How do you load first and last records into target table?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
tell me the push down optimization
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
Teradata 
