Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain the difference between a data warehouse and a data mart?

1056


Why is sorter an active transformation?

1125


What is the advantage of informatica?

1065


How to join three sources using joiner?

1100


without table how to come first record only in oracle?

2250


Enlist few areas or real-time situations where informatica is required.

1078


what is the size of u r source(like file or table)?

2267


What are the tuning techniques you applied during your last project

2022


What are the different versions of informatica?

1259


What is standalone command task?

1311


What are the differences between a connected lookup and unconnected lookup?

1068


What are the performance considerations when working with aggregator transformation?

1149


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2060


Define pmcmd command?

1037


What is an expression transformation?

1010