Can we use Union Transformation for Heterogeneous sources?
i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Answer Posted / ananta mishra
yes
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a standalone command task?
Differentiate between a database and data warehouse?
Explain the aggregator transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
differences between service based and product based?
Describe data concatenation?
What is blocking transformation?
What are the types of data warehouses?
What are the guidelines to be followed while using union transformation?
Is there any target staging area in informatica not staging area
What is informatica? Why do we need it?
Can we override a native sql query within informatica?
What is workflow? What are the components of workflow manager?
Write the prerequisite tasks to achieve the session partition?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?