which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
Answer Posted / raghu
aggregater is costliest bcoz it have cache, remaing d'snt
have cache
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What are the tuning techniques you applied during your last project
what is degenerated dimension?
write a query to retrieve the latest records from the table sorted by version(scd)
State the limitations where we cannot use joiner in the mapping pipeline?
What is target designer and target load order?
Difference between Target-based loading and constraint-based loading?
What do you mean by worklet?
Define joiner transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is a repository? And how to add it in an informatica client?
What is the procedure for creating independent data marts from informatica 7.1?
What is data transformation manager process?
What can we do to improve the performance of informatica aggregator transformation?
How to create the source and target database connections in server manager?