Interested to Buy Any Domain ? << Click Here >> for more details...
how can u tune u r informatica mapppings
- 2 Answers
- 9448 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
mappings can be tuned at diff transformations level.
ex; look up can be optimised by enabling the cache.
aggregator can be optimised by using sorted inout.
filter can be optimised by using it as close as possible
to the sql. so on
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vdrona
Mapping can be tuned by identifying the following bottlenecks in order shown below.
1. Target Bottlenecks
2. Source Bottlenecks
3. Transformation/Mapping Bottlenecks
4. Session Bottlenecks
5. System Bottlenecks
| Is This Answer Correct ? | 6 Yes | 1 No |
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
What is mapplet and a reusable transformation?
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
What is the meaning of up gradation of repository?
List the transformation in informatica.
why dimenstion tables are denormalized in nature ?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
with out using update strategy transnsformation how to update the data in mapping level
How to go to the older version for a mapping?
What is Micro Strategy? Why is it used for?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
Write the prerequisite tasks to achieve the session partition?
Teradata 
