Interested to Buy Any Domain ? << Click Here >> for more details...
in performance wise union is past,union all is past
- 2 Answers
- 5531 Views
- I also Faced
- E-Mail Answers
Answer Posted / aparna
Performance wise Union All is faster , because Union removes the duplicate records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the uses of etl tools?
What is the function of union transformation?
What is decode in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the use of source qualifier?
Is stop and abort are same in informatica?
How to create a non-reusable instance of reusable transformations?
design of staging area?
What are the new features of informatica 9.x in developer level?
How can we create index after completion of load process?
How can we store previous session logs?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Briefly explain the aggregator transformation?
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
