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 are the deliverables?in your project?
Define filter transformation?
Explain in detail scd type 2 through mapping.
What is the sql query overwrite in source qualifier in informatica
What is event and what are the tasks related to it?
What are the guidelines to be followed while using union transformation?
What is the scenario which compels informatica server to reject files?
What are the components of Informatica? And what is the purpose of each?
To import the flat file definition into the designer where should the flat file be placed?
What are the restrictions of union transformation?
What is the benefit of session partitioning?
Separate from a database, an information bazaar, and an information stockroom?
How to use pmcmd utility command?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?