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
- 13305 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
What is a standalone command task?
How many ways a relational source definition can be updated and what are they?
If informatica has its scheduler why using third party scheduler?
What are the static cache and dynamic cache in informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What do think which one is the better joiner or look up?
While migrating the data from one environment to another environment how would you manage the connections?
What is an expression transformation in informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the surrogate key?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is blocking transformation?
Repository user profiles
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
