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
Explain how many types of dimensions are available in informatica?
How can you define user defied event?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
r u done any partitions in ur project?
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.
Explain what is informatica metadata and where is it stored?
Explain the types of transformations?
What are pre and post-session shell commands?
lookup transformation with screenshots
Make a note of the quantity vaults made in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What is a filter transformation?
How we can use union transformation?
Performance tuning in UNIX for informatica mappings?
What do you mean by enterprise data warehousing?