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 / chandranmca2007

We can create a a dummy columns for both tables using that
dummy column we can join the both tables. If the both
tables have same column means we can using that join the
both tables.

If I wrong please send the answer to my mail id
chandranmca2007@gmail.com

Is This Answer Correct ?    21 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many dimensions are there in informatica?

1083


What is rank index in rank transformation?

1078


How to join three sources using joiner?

1105


Is it possible to define a single node as a Gateway node as well as worker node?

1121


What is meant by active and passive transformation?

1123


 Informatica Checkpoints

3328


difference between repository database and repository service?

1150


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1246


What does role playing dimension mean?

1044


What is DR strategy for Informatica project?

1173


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1122


What is meant by a domain?

1123


What do mean by local and global repository?

1225


What do think which one is the better joiner or look up?

1203


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1492