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
What is dimensional table?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the guidelines to be followed while using union transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How can we remove the duplicates from flat file source?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the types of data warehouses?
What is decode in informatica?
How would you join a node to the already existing domain?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is workflow manager?
What is status code in informatica?
What is a code page?