After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how?
Answer Posted / 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 |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a passive transformation?
Why is sorter an active transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is SDLC way of code development?
Differentiate between Load Manager and DTM?
What is xml source qualifier transformation in informatica?
What is dimensional table? Explain the different dimensions.
What do you understand by a term domain?
what are the deliverables?in your project?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Define mapplet?
What is a dimensional model?
What is decode in static cache?
What are the different types of transformation available in informatica.