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 the difference between informatica6.1 and infomatica7.1
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain the shared cache and re-cache?
Whats there in global repository
Briefly define reusable transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the main issues while working with flat files as source and as targets ?
Is it possible to revert a global repository to local one and why?
How can you define user defied event?
How do you convert single row from source into three rows into target?
What are the new features of informatica 9.x developer?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
State the differences between sql override and lookup override?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is domain and gateway node?