in performance wise union is past,union all is past
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 |
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
Enlist the differences between database and data warehouse.
What is a design?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
write a query to retrieve the latest records from the table sorted by version(scd)
In development project what is the process to follow for an etl developer from day1
difference between repository database and repository service?
How to display First letter of Names in Caps?