how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 3622 Views
- I also Faced
- E-Mail Answers
Answer Posted / chintan thakkar
It should always be done at SQ level, that will improve the performance of the mapping since informatica stores a cache for aggregator transformation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List few etl bugs?
Give the benefits of data integration suite?
what is data modeling?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
State the differences between shortcut and reusable transformation
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What is the difference between Data Warehousing and Data Mining?
Explain and compare etl & manual development?
what is dynamic insert?
What are the ETL Testing Operations?
How to delete data which is not in source table?
How to fine tune mappings?
what are the concerns of OLTP and DSS systems?
what are the concerns of OLTP and DSS systems?
