Interested to Buy Any Domain ? << Click Here >> for more details...
in performance wise union is past,union all is past
- 2 Answers
- 5448 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
What is informatica etl tool?
How can you generate reports in informatica?
Explain sessions?
Did u used latest transformations of 8.6.0? for what?
What is the procedure for creating independent data marts from informatica 7.1?
Explain scd type 3 through mapping.
write a query to retrieve the latest records from the table sorted by version(scd)
What is meant by incremental aggregation?
Why update strategy and union transformations are active? Explain with examples.
Differentiate between source qualifier and filter transformation?
Explain the aggregator transformation?
What are the different types of repositories created using informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
