Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 10170 Views
- TCS, I also Faced
- E-Mail Answers
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 are mapplets? How is it different from a Reusable Transformation?
What is an incremental loading? in which situations we will use incremental loading
what are challenges that you faced in testing? give solution to it?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
in static and dynamic which one is better
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
What are the joiner caches?
what are the challenge face in u r project?explain me
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
Teradata 
