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


Please Help Members By Posting Answers For Below Questions

What is a sorter transformation?

657


What is the use of transformation?

569


What does command task mean?

606


What is powercenter on grid?

689


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1893






Why filter transformation is an active one?

561


What are the restrictions of union transformation?

575


Explain in detail scd type 2 through mapping.

609


What is decode in static cache?

586


Explain in detail about scd type 1 through mapping.

584


What is the use of source qualifier?

668


How to improve the performance of a session using sorter transformation?

686


What is xml source qualifier transformation in informatica?

710


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1446


Differentiate between reusable transformation and mapplet.

568