i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task
Answer Posted / kumar
Hi Gurus,
can anyone please explain performance tuning above logic. If multiple sources are coming from multiple databases.
Not simple use Unioni/ Joinder T/R.
Please be patience.. your explanation is very helpful to us.
thanks in advance
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we use batches?
How can a transformation be made reusable?
draw informatica architecture 8.6 ?
What is a pre-defined event and user-defined event?
Explain constraint based loading in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a sequence generator transformation?
What is informatica?
How to update a particular record in target with out running whole workflow?
What is persistent lookup cache?
tell me about your project functionality
What is the Process to creating lookup transformation in informatica
Clarify the utilization of aggregator cache record?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the prerequisite tasks to achieve the session partition?