How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 13931 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramz
use Cartesian product or cross join
select required columns from tab1,tab2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
which one is better performance wise joiner or look up
What are the guidelines to be followed while using union transformation?
What is the session task and command task?
Enlist the tasks for which source qualifier transformation is used.
What are the different types of repositories created using informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Name the different lookup cache(s)?
difference between repository database and repository service?
How can we update a record in the target table without using update strategy?
What are the types of presistent cache in look up tr.
How to load data in informatica ?
Enlist the advantages of informatica.
How to generate sequence numbers without using the sequence generator transformation?
What are the different ways to implement parallel processing in informatica?
Is there any way to read the ms excel datas directly into informatica?
