i have two source data there is no pk,fk how to join the
two sources
Answer Posted / ash
use joiner and create 2 ports in jnr and assign the default value 1 to each of the ports.
make sure that 1 port is master port and [ the other post is detail]. Now give the condition as new-masterport=new_detailsport.
This will give the cartesian product type of join.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
What are the differences between oltp and olap?
differences between service based and product based?
Clarify the utilization of aggregator cache record?
What are the new features of informatica 9.x developer?
Can u generate reports in Informatica?
Implementation methodology
What is primary and backup node?
Explain the etl program with few examples.
difference between repository database and repository service?
How to update a particular record in target with out running whole workflow?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the difference between a connected look up and unconnected lookup?
Why sorter is an active transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?