After draging the ports of three sources(sql
server,oracle,informix) to a single source qualifier, can
you map these three ports directly to target?
Answer Posted / bidhar
You cannot join Hetrogeneous sources in a SQ.For that you
need use joiner.For example if you have n hetrogeneous
sources then you must use n-1 joiners.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
Where are the source flat files kept before running the session?
What is the difference between informatics 7x and 8x and what is latest version?
How to load a Dimension ? and how to load a fact table?
How to load data in informatica ?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Tell me about Propagate functions in informatica
Explain the types of lookup transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
how to create user defined function (udf) in informatica
What are the popular informatica products?
How to configure mapping in informatica?
Explain sessions?
What is informatica? Why do we need it?