what is incremental loading ?
Answer Posted / kesava
Incremental aggregation is defined as the integration service performs aggregate calculations & stores the data in history cache & it reads only new data when it loads the new data ...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the function of aggregator transformation?
In which transformation you cannot drag ports into it?
What is a passive transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Why update strategy and union transformations are active? Explain with examples.
Explain in detail scd type 2 through mapping.
How many number of sessions can one group in batches?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
how many types of dimensions are available in informatica?
Differentiate between router and filter transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is option by which we can run all the sessions in a batch simultaneously?
How do you migrate data from one environment to another?
Different circumstance which drives informatica server to expel records?
How you prepared reports for OLAP?