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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Can anyone please distinguish what is Inner join and Outer join

Question Posted / sehaj

Answer Posted / sehaj

INNERJOIN-GIVES THAT RECORDS THAT ARE PRESENT IN BOTH THE TABLE
OUTERJOIN-GIVES THAT RECORDS WHICH ARE PRESENT AND ALSO
WHICH ARE NOT PRESENT IN ONE OF THE TABLE.

INEERJOIN-REQUIRES LESS PROCCESING TIME.
OUTERJOIN-REQUIRES THE MAX PROCESSING TIME AMONG ALL THE
KIND O JOINS.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What you know about transaction control transformation?

980

what is INFORMATICA TESTING process

2277

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2083

What is an expression transformation?

1000

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1898

Clarify the utilization of aggregator cache record?

984

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1117

What are session parameters ? How do you set them?

1829

What are some examples of informatica etl programs?

919

How will the document be delivered to me?

1063

tell me about your project functionality

2331

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1263

What is informatica metadata and where is it stored?

979

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1055

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2302