i have two source data there is no pk,fk how to join the
two sources
Answer Posted / tauseef
if the two sources or coming from same datasource then we
can use source Qualifier trans to join
if it is coming from different then same add a dummy port on both the tables and join
if its wrong send me the soulution to my id tauseefwst@yahoo.com
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between source qualifier transformations source filter to filter transformation?
What is a surrogate key?
What is the sql query overwrite in source qualifier in informatica
can we override a native sql query within informatica? How do we do it?
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
How many transformations can be used in mapplets.
have u done any performance tuning? how u ll do?
What is meant by LDAP users?
what is the size of your data warehousing?
How to update source definition?
Explain lookup transformation is active in informatica
Can we create two repositories on same database instance in oracle?
What is the benefit of session partitioning?
What is an Integration service in Informatica?
expain about the tune parameters?