How can you increase the performance in joiner transformation?
What are the restrictions of union transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How can we update a record in the target table without using update strategy?
What are the advantages of informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
What is persistent lookup cache?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the uses of etl tools?
What are pre and post-session shell commands?
How does the aggregator transformation handle null values?
What are the performance considerations when working with aggregator transformation?
When do you use sql override in a lookup transformation?
How does a sorter cache works?
State the differences between sql override and lookup override?