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

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4109


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2747


Explain the tuning lookup transformation - informatica

996


Explain sessions and how many types of sessions are there?

1011


Explain the mapping variable usage example in informatica

1165


How to extract sap data using informatica? What is abap? What are idocs?

1182


Can we create two repositories on same database instance in oracle?

1094


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2159


How to configure mapping in informatica?

1173


Implementation methodology

1714


What is workflow manager?

1049


What is informatica worklet?

1067


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641


How to generate or load values in to the target table based on a column value using informatica etl tool.

1076


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251