Interested to Buy Any Domain ? << Click Here >> for more details...
in performance wise union is past,union all is past
- 2 Answers
- 5353 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aparna
Performance wise Union All is faster , because Union removes the duplicate records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can anyone tell me the new features in Informatica 9 Version?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
How You Pull the records on daily basis into your ETL Server.
Plz..let me know differences between Informatica 7.1 and 8.1?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
What is a rank transform?
Under what condition selecting sorted input in aggregator may fail the session?
What is sq transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the types of presistent cache in look up tr.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Teradata 
