how to connect two or more table with single source qualifier?
Answer Posted / sukanta
Drag two tables to mapping designer.Now with two tables two
source qualifier has come to the workspace among which you
delete second source's source qualifier.Now drag all ports
from 2nd source to first source qualifier.Now the first
qualifier have contained all ports of two sources.
But before than that in source analyzer you make a PK-FK
relation between two sources.Now in the source qualifier you
make a join condition upon that two port for PK-FK.
You get the solution.
Regards
Sukanta
Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain the informatica workflow?
What are the limitations of joiner transformation?
Differentiate between a repository server and a powerhouse?
Did u used latest transformations of 8.6.0? for what?
Explain incremental aggregation in informatica
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
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How many transformations can be used in mapplets.
Explain the different lookup methods used in informatica?
without table how to come first record only in oracle?
What is different between the data warehouse and data mart?
Parameter and variable differences
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?