How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
can u give example for factless fact table
What is the benefit of partitioning a session?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What can we do to improve the performance of informatica aggregator transformation?
What is the meaning of decode in informatica?
What is exclusive and normal mode for repository services?
How to generate sequence numbers?
How would you join a node to the already existing domain?
Write the advantages of partitioning a session?
Sequence generator, when you move from develoment to production how will you reset
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to implement security measures using repository manager?
What are the tuning techniques you applied during your last project
pmscmd startworkflow -sv