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

explain about lookup t/r?

Answer Posted / suraj kedia

Look up t/r is used in a mapping to look up data in a
relational table,flat file,view or synonym.

The informatica server queries the look up source based on
the look up ports in the transformation.It compares look up
t/r port values to look up source column values based on the
look up condition.
Look up t/r is used to perform the below mentioned tasks:

1) To get a related value.
2) To perform a calculation.
3) To update SCD tables.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the tasks that source qualifier perform?

1141


What are the different components of powercenter?

1107


What are data-driven sessions?

1255


State the limitations where we cannot use joiner in the mapping pipeline?

1103


Repository user profiles

1802


explain abt ur project architecture?

2229


In which transformation you cannot drag ports into it?

1372


Briefly describe lookup transformation?

1090


Differentiate between reusable transformation and mapplet.

1138


What is mapplet in informatica?

1120


Explain Dataware house architecture .how data flow from intial to end?

2640


What is informatica etl tool?

1052


How to go to the older version for a mapping?

1149


What do you mean by blocking transformation?

1111


What are the types of schemas we have in data warehouse and what are the difference between them?

983