What is incremental aggregation and how it is done?
Answer Posted / ankit kansal
Incremental Aggregation ->
Incremental Aggregation is a technique to populate data on your aggregated tables or materialized view incrementally.
It takes new incoming data only based upon last updated column value or created_date time stamp column and thus uses its own cache created/updated earlier and updated the table as required.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
what is the -ve test case in your project.
What is exclusive and normal mode for repository services?
Can you generate sequence numbers without using the sequence generator transformation?
What are batches?
What is expression transformation?
Where can we find the throughput option in informatica?
Performance tuning( what you did in performance tuning)
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is source qualifier transformation in informatica?
Whats there in global repository
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the different types of repositories created using informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
list out all the transformations which use cache?