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 are the various types of transformation?

1162


Target increases every day even though no new record was inserted

1565


how to create user defined function (udf) in informatica

1290


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

1920


How does a sorter cache works?

1048


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1028


What is status code in informatica?

1006


Why do you use Mapping Parameter and mapping variable?

1747


Explain the informatica workflow?

1039


How to generate or load values in to the target table based on a column value using informatica etl tool.

1054


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2119


Is stop and abort are same in informatica?

989


How many numbers of sessions can one group in batches?

1054


What are the different clients of powercenter?

1045


what is the -ve test case in your project.

2395