Answer Posted / abhinaw prakash
When we want to Update the Target without any Primary key
but with matching columns then we ll go for Target update
override.
The Integration service outputs a Default query,we need to
make the changes according to the column we want to Update.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the benefit of partitioning a session?
What is meant by incremental aggregation?
Write the different tools in the workflow manager?
How we can use union transformation?
Differences between connected and unconnected lookup?
differences between service based and product based?
What is aggregate cache in aggregator transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Why is sorter an active transformation?
Name the different lookup cache(s)?
How many ways are there to create ports?
How to load last n records of file into target table - informatica
What is the Process to creating lookup transformation in informatica
Explain what transformation and how many are there in informatica?