Interested to Buy Any Domain ? << Click Here >> for more details...
in performance wise union is past,union all is past
- 2 Answers
- 5305 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
Where do we use mapping variables in informatica?
what is mean by complex business rule ?
How to do unit testing in informatica? How to load data in informatica ?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain lookup transformation source types in informatica
How identifying bottlenecks in various components of informatica and resolving them?
How to generate sequence numbers using expression transformation?
What is an expression transformation?
How to create a non-reusable instance of reusable transformations?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
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?
What is joiner transformation in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain about Informatica server process that how it works relates to mapping variables?
