Interested to Buy Any Domain ? << Click Here >> for more details...
how can u tune u r informatica mapppings
- 2 Answers
- 9308 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 |
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What do you understand by a term domain?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
what is incremantal aggregation?
What are teh different tasks that can be created in workflow manager?
What is domain and gateway node?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
Plz..let me know differences between Informatica 7.1 and 8.1?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
server hot-ws270 is connect to Repository B. What does it mean?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
What is query panel?
Teradata 
