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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How do you load only null records into target?
How can we create index after completion of load process?
Explain how to import oracle sequence into informatica?
What are the features of complex mapping?
What are the components of workflow manager?
How might one distinguish in the case of mapping is right or not without associating session?
How to configure mapping in informatica?
How do you update the records with or without using update strategy?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
generate date / time dimension in informatica
What is a node in Informatica?
Write the different tools in the workflow manager?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?