Interested to Buy Any Domain ? << Click Here >> for more details...
How to identify bottlenecks in
sources,targets,mappings,workflow,system and how to
increase the performance?
- 4 Answers
- 35280 Views
- I also Faced
- E-Mail Answers
Answer Posted / praveenkumar.b
Source:
Create the Filter transformation after all the Source
Qualifiers and make the filter condition FALSE so that the
data will not go beyond this trasformation. Then run the
session and find out the time taken from source. If you
feel there is some lack in performance, then suggest the
necessary index creation in Pre Session.
Note: If the source is File, then there is no possibility
of performance problme in source side
Target:
Delete the target table from the mapping and create the
same structure as a Flat file. Run the session and find out
the time taken to write the file. If you feel problem in
performance, then delete the INDEX of the table before
loading the data. In post Session, Create the same index
Note:If the target is File, then there is no possibility of
performance problme in target side
Mapping:
The below steps need to be consider
#1. Delete all the transformations and make it as single
pass through
#2. Avoid using more number of transformations
#3. If you want to use more filter transformation, then use
Router transformation instead of it
#4. Calculate the index and data cache properly for
Aggregator, Joiner, Ranker, Sorter if the Power center is
lower version. Advance version, Power center itself will
take care of this
#5. Always pass the sorted i/p's to Aggregator
#6. Use incremental aggregation
#7. Dont do complex calculation in Aggregator
transformation.
Session:
Increas the DTM buffer size
System:
#1. Increase the RAM capacity
#2. Avoid paging
| Is This Answer Correct ? | 27 Yes | 1 No |
Post New Answer View All Answers
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to go to the older version for a mapping?
What are the databases that informatica can connect to windows?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is domain and gateway node?
is it possible to index the data in cache of lkp transformation ?
What will be the approach?
What are connected or unconnected transformations?
What are the advantages of using informatica as an etl tool over teradata?
If informatica has its scheduler why using third party scheduler?
What are the issues you have faced in your project? How did you overcome those issues?
what is the size of your data warehousing?
In development project what is the process to follow for an etl developer from day1
How to generate sequence numbers?
