what is incremantal aggregation?
Answer / swetha
When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes only incrementally and you
can capture changes, you can configure the session to
process only those changes. This allows the Informatica
Server to update your target incrementally, rather than
forcing it to process the entire source and recalculate the
same calculations each time you run the session.
Is This Answer Correct ? | 4 Yes | 0 No |
What are the data movement modes in informatica?
What is the difference between a router and a filter transformation?
What are the types of schemas we have in data warehouse.
Can we create a Integration service without a Repository service and vice versa?
How to do the error handling of if ur source is flatfiles?
What is the need for an etl tool?
what is diff b/t sorter t/r and agg have the option sorter property...
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain lookup transformation in informatica
What are the differences between a connected lookup and unconnected lookup?
What is the sequence generator transformation in informatica?