Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 39157 Views
- JPMorgan Chase, TCS, I also Faced
- E-Mail Answers
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
What are the informatica performance improvement tips
How do you load alternate records into different tables through mapping flow?
What are the restrictions of union transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a sequence generator transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the differences between oltp and olap?
Explain what is informatica metadata and where is it stored?
How can one identify whether mapping is correct or not without connecting session?
What are the limitations of joiner transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is rank transformation in informatica
Different sorts of metadata that stores in the storage facility?
