Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / lokendra
The first time you run an incremental aggregation session,
the PowerCenter Server processes the entire source. At the
end of the session, the PowerCenter Server stores aggregate
data from that session run in two files, the index file and
the data file. The PowerCenter Server creates the files in
a local directory.
Each subsequent time you run the session with incremental
aggregation, you use only the incremental source changes in
the session.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What can we do to improve the performance of informatica aggregator transformation?
Explain in detail about scd type 1 through mapping.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Differentiate between a repository server and a powerhouse?
How to convert multiple rows to single row (multiple columns) in informatica
difference between repository database and repository service?
Explain scd type 3 through mapping.
Under which circumstances, informatica server creates reject files?
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
What is incremental aggregation?
What are the types of lookup transformation?
How can we store previous session logs?
How you can differentiate between connected lookup and unconnected lookup?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
