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

Explian the connected and unconnected lookup transformation

Answer Posted / hari

Connected lookup
1.input ports are connected through pipeline
2.we can have more inputs and more outputs
3connected lookup we can use both static and dynamic cache
4.if condition not match default it give values

Unconnected lookup
1. Inputs are connected through calling :LKP from expression
2.inputs are more and output returns one
3.only static cache can use
4.if condition not match it gives nulls

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What differs when we choose the sorted input for aggregator transformation?

967


How to do unit testing in informatica? How to load data in informatica ?

1048


What is exclusive and normal mode for repository services?

1062


What are the main features of Oracle 8i with context to datawarehouse?

2052


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6910


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1095


What are the differences between a connected lookup and unconnected lookup?

1015


Where do we use mapping variables in informatica?

996


expain about the tune parameters?

2338


Explain in detail scd type 2 through mapping.

986


What is domain and gateway node?

1119


What is session task and command task?

1177


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1865


What is the use of target designer?

981


where to store informatica rejected data?

1046