Interested to Buy Any Domain ? << Click Here >> for more details...
in performance wise union is past,union all is past
- 2 Answers
- 5401 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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Repository user profiles
What are the new features of informatica 9.x at the developer level?
What is InformaticaPowerCenter?
Briefly explain the aggregator transformation?
which one is better performance wise joiner or look up
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Please let me know how to make encryption and decryption with example?
What is lookup change?
Enlist the tasks for which source qualifier transformation is used.
Differentiate between sessions and batches?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the informatica performance improvement tips
