Interested to Buy Any Domain ? << Click Here >> for more details...
in performance wise union is past,union all is past
- 2 Answers
- 5533 Views
- I also Faced
- E-Mail Answers
Answer Posted / jz
Performance wise Union all is Fast.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain load alternative records / rows into multiple targets - informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Mention some types of transformation?
What are the different versions of informatica?
What is joiner transformation in informatica?
What is confirmed fact in dataware housing?
What does refresh system mean, and what are its distinctive choice?
Enlist the various types of transformations.
What are the types of presistent cache in look up tr.
Name the different lookup cache(s)?
how tokens will generate?
What is the difference between informatica 7.0 and 8.0?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the difference between Active and Passive transformation?
