How can we join the tables if they don't have primary and
foreign key relationship and no matching port?

Answer Posted / lokesh

Manually add dummy cols to both table with same data type and join dem with joiner transformation

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does a sorter cache works?

669


How we can create indexes after completing the loan process?

841


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2026


What is meant by LDAP users?

781


What are mapplets?

915






What is the use of transformation?

660


expain about the tune parameters?

2008


how tokens will generate?

1845


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1625


Can informatica load heterogeneous targets from heterogeneous sources?

815


What are the components of the workflow manager?

755


What is an expression transformation?

708


What is incremental aggregation?

677


Can we create two repositories on same database instance in oracle?

713


What is joiner change?

807