how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 3615 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is data modeling and data mining?
Difference between flat files and relational sources?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
how do u implement configuration management in Informatica?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is Relational Integrity?
what is the meaning of upgradation of Repository?
List few etl bugs?
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 partitioning? Explain different types of partitioning?
How to fine tune mappings?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Teradata 
