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|
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain factlessfact table with scenario
explan ur project architecture?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
What r the type of indexes u generally used in informatica?
Define joiner transformation?
How to delete first 3 rows & last 3 rows in target table in informatica
What do think which one is the better joiner or look up?
Differentiate between a database and data warehouse?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
What is parallel processing in informatica?
how to obtain performance data for individual transformations.