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


Please Help Members By Posting Answers For Below Questions

what are the deliverables?in your project?

1769


Define filter transformation?

718


Explain in detail scd type 2 through mapping.

730


What is the sql query overwrite in source qualifier in informatica

709


What is event and what are the tasks related to it?

706






What are the guidelines to be followed while using union transformation?

742


What is the scenario which compels informatica server to reject files?

709


What are the components of Informatica? And what is the purpose of each?

694


To import the flat file definition into the designer where should the flat file be placed?

748


What are the restrictions of union transformation?

672


What is the benefit of session partitioning?

700


Separate from a database, an information bazaar, and an information stockroom?

701


How to use pmcmd utility command?

684


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

726


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5450