Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 38795 Views
- JPMorgan Chase, TCS, I also Faced
- E-Mail Answers
Answer Posted / bharat
Incremental aggregation is a technique by which we can
capture the aggregated data incrementally.
for this we have to sort the data before sending it to
aggregator then we have to enable the property incremental
aggregation in the workflow level inside the session.
| Is This Answer Correct ? | 11 Yes | 9 No |
Post New Answer View All Answers
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How do you migrate data from one environment to another?
What is the procedure for creating independent data marts from informatica 7.1?
To import the flat file definition into the designer where should the flat file be placed?
Enlist the advantages of informatica.
What are some examples of informatica etl programs?
Enlist few areas or real-time situations where informatica is required.
How to go to the older version for a mapping?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Performance tuning( what you did in performance tuning)
Why update strategy and union transformations are active? Explain with examples.
Differentiate between source qualifier and filter transformation?
What is informatica metadata and where is it stored?
How big was your fact table
Mention a few design and development best practices for informatica?
