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
Explain the difference between a data warehouse and a data mart?
Why is sorter an active transformation?
What is the advantage of informatica?
How to join three sources using joiner?
without table how to come first record only in oracle?
Enlist few areas or real-time situations where informatica is required.
what is the size of u r source(like file or table)?
What are the tuning techniques you applied during your last project
What are the different versions of informatica?
What is standalone command task?
What are the differences between a connected lookup and unconnected lookup?
What are the performance considerations when working with aggregator transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Define pmcmd command?
What is an expression transformation?