how can we use sorter transformation in joins?
Answer Posted / m
To improve the perfomance we have to check the button "sorted input" ,
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the benefit of partitioning a session?
Where can we find the throughput option in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
Explain the types of transformations?
Clarify the aggregator change?
How many dimensions are there in informatica?
Write the different tools in the workflow manager?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
which one is better performance wise joiner or look up
Is it possible to revert a global repository to local one and why?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Differentiate between router and filter transformation?
What do you mean by enterprise data warehousing?