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?
- 6 Answers
- 10905 Views
- I also Faced
- E-Mail Answers
Answer Posted / atiric software(raja)
we cannot join haterogeneous sources in the s.q so we
cannot map those ports to target directly if we want we must
use the joiner transformation
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a filter transformation and why it is an active one?
explan ur project architecture?
whats the logic to load the lower level of granularity of data to fact table.
explain about unit testing? in real time?
How many types of sessions are there in informatica.please explain them?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What happens when a session fails and you click on recover?
What is expression transformation?
How identifying bottlenecks in various components of informatica and resolving them?
design of staging area?
What is the cumulative sum and moving sum?
How can we handle two sessions in informatica?
What is the command used to run a batch?
Differentiate between a repository server and a powerhouse?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
