How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 13991 Views
- I also Faced
- E-Mail Answers
Answer Posted / developer
use a union transformation if there are no matching ports.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Whats there in global repository
Which means the first record should come as last record and last record should come as first record and load into the target file?
waht type of interface is used for testing the data in informatica
What is olap (on-line analytical processing?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
explain one complex mapping with logic? sales project?
Can u generate reports in Informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is domain in terms of informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Repository user profiles
What is different between the data warehouse and data mart?
Define the various join types of joiner transformation?
What do you mean by filter transformation?
