After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how?
Answers were Sorted based on User's Feedback
Answer / rao
How can you join 3 heterogeneous sources to a single source
qualifier?.
For this you need to use 2 joiner transformations and the
resulted cloumns can be connected to the target.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / veeru
No,
By joining the three sources, we can load in to the target
Is This Answer Correct ? | 0 Yes | 5 No |
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?
Enterprise data warehouse your projects phase by phase explain?
Define informatica repository?
Explain the features of connected and unconnected lookup.
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
How the informatica server sorts the string values in Rank transformation?
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
How i can upload the MainFrame source For Informatica ?
How to create or import flat file definition in to the warehouse designer?
Briefly define reusable transformation?
how u know when to use a static cache and dynamic cache in lookup transformation.