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
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the new features of informatica 9.x in developer level?
Why filter transformation is an active one?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Do you find any difficulty while working with flat files as source and target?
What is parallel processing in informatica?
What is sequence generator transformation in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
How to elaborate tracing level?
What do you mean by blocking transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Differentiate between source qualifier and filter transformation?
What is the advantage of informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
While importing the relational source definition from the database, what are the metadata of source that will be imported?