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 / chandrababu.sarupuru

To join these sources we will use SQL Override function in
Source qlalifier transformation....

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank transformation?

991


What if the source is a flat-file?

1111


In development project what is the process to follow for an etl developer from day1

1724


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675


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

1122


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2340


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2120


As union transformation gives UNION ALL output, how you will get the UNION output?

1108


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2169


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

1125


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?

1497


How to convert multiple rows to single row (multiple columns) in informatica

1381


How many transformations can be used in mapplets.

1935


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

5791


What are the reusable transformations?

1166