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 a diff between joiner and lookup transformation

Answer Posted / kittu

hi every one

i read all the answers i agree with you but one more thing is there in joiner. once u specify d joiner it will extract all the data from source and check the based on condition then it returns values.

in look up it wont take any values but it refers based on condition.It means look up check the values present r not.
here main thing is memory if cache size is increase it decrease the informatica performance.same thing will happen in joiner trans so mostly we r not using joiner but some times based on source data we use.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Implementation methodology

1667


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

1896


Why union transformation is an active transformation?

1003


generate date / time dimension in informatica

1084


What is the session task and command task?

1006


How to improve the performance of a session using sorter transformation?

1113


can u any challenge your project?

1984


Explain your project of banking domian.

1619


What do you understand by a term domain?

1083


4 yrs etl devloper roles and responsibilities?any body give solutions

2100


COM components can be used in Informatica

2337


Write the prerequisite tasks to achieve the session partition?

1098


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2688


What is transformation?

1063


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1911