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?
Answers were Sorted based on User's Feedback
Answer / chandrababu.sarupuru
Union Transformation allows the Hetrogeneous sources .
So you can join the sources which are having same metadata.
| Is This Answer Correct ? | 12 Yes | 0 No |
What is limitations of truncate and load option
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
What is update override?
What are the join types in joiner transformation?
with out using update strategy transnsformation how to update the data in mapping level
Can we run session without using workflows?
Useful UNIX commands regular/frequently used
How to load time dimension?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
how can run the wf through pmcmd commend? write script?