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

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

1107


Describe expression transformation?

1170


Explain the scenario which compels informatica server to reject files?

1209


r u done any partitions in ur project?

1866


Is it possible to revert a global repository to local one and why?

1136


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4780


How do you take back up of repository?

1209


Explain the mapping variable usage example in informatica

1224


What is the different lookup cache(s)?

1131


What is mapplet in informatica?

1129


Define pmcmd command?

1106


What does update strategy mean, and what are the different option of it?

1141


Can you use flat files in Mapplets.

2715


have u done any performance tuning? how u ll do?

2367


Suppose we do not group by on any ports of the aggregator what will be the output?

1098