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 |
In which circumstances that informatica server creates Reject files?
Explain how many types of dimensions are available in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
Can i create a lookup table without cache.
how many ways can we implement SCD2?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what is the dashbords?
why sequence generator should not directly connected to joiner transformation ?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.