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

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1980


Explain scd type 3 through mapping.

1022


Explain what transformation and how many are there in informatica?

960


How to extract sap data using informatica? What is abap? What are idocs?

1183


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

1080


How does the aggregator transformation handle null values?

1150


Difference between Target-based loading and constraint-based loading?

1008


what is the -ve test case in your project.

2409


What is a connected transformation?

1125


What are the differences between oltp and olap?

973


Explain why we use partitioning the session in informatica?

1097


Can informatica load heterogeneous targets from heterogeneous sources?

1187


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1161


What is incremental aggregation?

1091


What is the difference between informatica 7.0 and 8.0?

1017