Interested to Buy Any Domain ? << Click Here >> for more details...
how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 27218 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / abhsihek
Hi neetu,
as i know that dynamic lookup alway increase the perfomence
compratively static cache if i am wrong please let me know.
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
Differentiate between reusable transformation and mapplet.
What do you understand by a term domain?
What is target designer and target load order?
What is a predefined event?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Clarify the aggregator change?
Explain how many types of dimensions are available in informatica?
How might you approve all mappings in the archive all the while?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Write the unconnected lookup syntax and how to return more than one column.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How do we call shell scripts from informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Reusable transformation and shortcut differences
What is meant by lookup transformation?
