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
How do you migrate data from one environment to another?
State the differences between sql override and lookup override?
How do you load only null records into target? Explain through mapping flow.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is joiner transformation?
Define enterprise data warehousing?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is a shortcut and copy in Informatica and how two are different with each other?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain sessions. Explain how batches are used to combine executions?
What is intricate mapping?
what is SDLC way of code development?
what is the difference between informatica6.1 and infomatica7.1
Which are the different editions of informatica powercenter that are available?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.