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

what is the complex transformation you used in informatica

2524


What are the differences between oltp and olap?

921


differences between service based and product based?

1970


Clarify the utilization of aggregator cache record?

943


What are the new features of informatica 9.x developer?

900


Can u generate reports in Informatica?

1025


Implementation methodology

1654


What is primary and backup node?

1081


Explain the etl program with few examples.

966


difference between repository database and repository service?

1081


How to update a particular record in target with out running whole workflow?

1533


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

1991


What is the difference between a connected look up and unconnected lookup?

910


Why sorter is an active transformation?

1130


-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?

5683