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
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Enlist the advantages of informatica.
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?
differences between service based and product based?
How does a rank transform differ from aggregator transform functions max and min?
Define mapplet?
On which transformations you created partitions in your project?
What is the sql query overwrite in source qualifier in informatica
Define filter transformation?
what is informatica metadata?
Which development components of informatica have the highest usage?
how to create user defined function (udf) in informatica
what is Active lock explain
How can we improve session performance in aggregator transformation?
Briefly define reusable transformation?