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

How many joins in Informatica

Answer Posted / maj

In this select query I think instead of LEFT OUTER
JOIN,Need to put "RIGHT OUTER JOIN"

SELECT * FROM employees LEFT OUTER JOIN departments ON
(employees.department_id = departments.department_id)

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load a Dimension ? and how to load a fact table?

1382


Have you worked with/created Parameter file

1629


Explain sessions?

998


tell me about your project functionality

2309


How to handle decimal places while importing a flatfile into informatica?

1147


How can we use mapping variables in informatica?

1019


What are the types of schemas we have in data warehouse and what are the difference between them?

908


What's the layout of parameter file (what does a parameter file contain?)?

2351


Explain the informatica workflow?

1020


State the limitations where we cannot use joiner in the mapping pipeline?

1015


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1737


What are the main issues while working with flat files as source and as targets ?

1116


What all join we can perform in LOOKUP transformation?

930


How can one identify whether mapping is correct or not without connecting session?

1401


What are the performance considerations when working with aggregator transformation?

1114