how can we use sorter transformation in joins?
Answer Posted / prasuna
You can improve session performance by configuring the
Joiner transformation to use sorted input.
To configure a mapping to use sorted data, you establish and
maintain a sort order in the mapping so the Integration
Service can use the sorted data when it processes the Joiner
transformation.
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
Define the various join types of joiner transformation?
What is the status code in stored procedure transformation?
What is the scenario which compels informatica server to reject files?
Explain sessions and how many types of sessions are there?
How you prepared reports for OLAP?
What is an expression transformation in informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
what are 3 tech challenges/ common issues you face?
What is different between the data warehouse and data mart?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Mention few advantages of router transformation over filter transformation.
update strategy transformation in informatica
what is the size of u r source(like file or table)?
What are the advantages of using informatica as an etl tool over teradata?