Define Incremental Aggregation?
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 |
Differentiate between a repository server and a powerhouse?
Where do we use mapping variables in informatica?
Scheduling properties,whats the default (sequential)
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
when we dont use aggregator in mapping ?
What are the new features of Power Center 5.0?
how to we create datamart?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
which transformation uses cache?
h0w many versions have been developed of onformatica so far?
what is the use of Java Transformation in Informatica 8.x?