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
What are the different types of transformation available in informatica.
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 are ETL Tools?
What is intricate mapping?
What are the different types of repositories created using informatica?
How can repository reports be accessed without sql or other transformations?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a sequence generator transformation?
What are the informatica performance improvement tips
Explain what is informatica metadata and where is it stored?
write a query to retrieve the latest records from the table sorted by version(scd)
What is Cognos script editor?
What is standalone command task?
What is meant by LDAP users?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not