Interested to Buy Any Domain ? << Click Here >> for more details...
In ur current projectu have done any performance tuning of
mappings?
- 1 Answers
- 4646 Views
- I also Faced
- E-Mail Answers
Answer / sreedhar lokaray
Many people are not sure how exactly to tune the
performance of a mapping. There is no thumb rule for
performance tuning. A tuning done in one mapping cannot be
applied into another mapping. But still below given are
some of the performance tuning tips.
Joiner instead of Lookup: If the lookup table has large no.
of records then the performance will affect because it has
to build the cache. Instead use a joiner transformation and
check it as detail rows. This will avoid building cache.
Sorted Input: Use sorter transformation before joiner or
aggregator. This will improve the performance.
Source Qualifier: Try to filter out unwanted records in the
source qualifier before moving to the next transformation.
Also delete unconnected/unused ports.
Indexes: Try to have proper indexes on the required fields
of the tables in the database which will increase the
performance. At the same time having indexes on the target
will kill the performance when you try to insert huge
volumes of data. To avoid this, disable the indexes on the
target (using sql loader direct load process) and then load
the data. After loading enable the index back.
Keep in mind that tuning performance of one transformation
can kill the performance of other transformation. We have
to maintain the equilibrium.
| Is This Answer Correct ? | 8 Yes | 0 No |
What is a surrogate key?
Explain the tuning lookup transformation - informatica
What are the mapings that we use for slowly changing dimension table?
what is dynamic cashe
What is the reusable transformation?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
what are presession,postsession success and postsession failure commands ?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
why we use datawarehouse
What is enterprise data warehousing?
In joiner, how to load Master table in Target?
Teradata 
