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
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
COM components can be used in Informatica
How do you load only null records into target?
Write the program through which the records can be updated?
What are the prerequisite tasks to achieve the session partition?
How to update a particular record in target with out running whole workflow?
What are junk dimensions?
Which files are created during the session rums by informatics server?
What is informatica etl tool?
What is the need of etl tools?
What is source qualifier transformation in informatica?
In informatics server which files are created during the session rums?
Did u used latest transformations of 8.6.0? for what?
Can we create multiple integration service on single repository?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?