Interested to Buy Any Domain ? << Click Here >> for more details...
which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
- 7 Answers
- 13638 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth
HI
Among those 3 trans, filter does not use cache.
so it should be either agg or sorter.
Both agg and sorter uses cache as they process data in a
dependable fashion for performing calculations and sorting
data before the result is passed to next transfomration.
WE cant say which one uses more space. it depends on the
size of source data we are processing.
Agg needs to perform calculations on groups of data but if
the data in sorter is more, it takes more space than agg to
hold the data.
for ex, we are sorting on character data, server needs to
use ASCII values of alphabets to sort in order.
It depends on the size of the source data.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the scenario which compels informatica server to reject files?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What differs when we choose the sorted input for aggregator transformation?
What is DR strategy for Informatica project?
What could be the possible resons of locks by user?
can we override a native sql query within informatica? How do we do it?
What is the status code in stored procedure transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the different types of transformation available in informatica.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What all are steps in up gradation of Informatica server?
