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

what is the diff b/w union and joiner and lookup?

Answer Posted / maruthi

union-can join two tables without common port
joiner-can join any two hetrogenous sources,but common port
is necessary.
lookup-we can join two tables by using sql over-ride,apart
from that we can check wether the row is already existing
or not.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write the prerequisite tasks to achieve the session partition?

1101


tell me the rules and responsblites in our project(my project is development)

1896


Design a mapping to load a target table with the following values from the above source?

1309


Explain the different kinds of facts.

948


Global and Local shortcuts. Advantages.

1987


How to elaborate powercenter integration service?

1090


How to update source definition?

1051


Can you generate sequence numbers without using the sequence generator transformation?

1074


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1973


wf dont have integration severances how you can run?

1904


What is the difference between STOP and ABORT options in Workflow Monitor?

1208


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2089


What is an expression transformation in informatica?

981


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6079


How do you migrate data from one environment to another?

1067