how can we use sorter transformation in joins?
Answer Posted / x
Hi,
In joiner T/S properties we have an option called sorter
input.
So by using this we can improve the session Performance
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is update strategy transform?
How does the aggregator transformation handle null values?
What does reusable transformation mean?
What are the components of workflow manager?
Which are the different editions of informatica powercenter that are available?
How to join three sources using joiner?
explain about unit testing? in real time?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
explain abt ur project architecture?
What is informatica etl tool?
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.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are mapplets? How is it different from a Reusable Transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
can we override a native sql query within informatica? Where do we do it? How do we do it?