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

Why use the lookup transformation ?

Answer Posted / swetha

To perform the following tasks.

Get a related value. For example, if your source table
includes employee ID, but you want to include the employee
name in your target table to make your summary data easier
to read. Perform a calculation. Many normalized tables
include values used in a calculation, such as gross sales
per invoice or sales tax, but not the calculated value (such
as net sales). Update slowly changing dimension tables. You
can use a Lookup transformation to determine whether records
already exist in the target.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is status code in informatica?

1015


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2117


How to go to the older version for a mapping?

1094


How union transformation is used?

1002


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2155


What are the mapping parameters and mapping variables?

1198


What is the cumulative sum and moving sum?

1183


What is the different lookup cache(s)?

1081


Under which circumstances, informatica server creates reject files?

1085


Slowly changing dimensions, types and where will you use them

1710


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3861


Explain what are the different types of transformation available in informatica.

1139


Enlist the various types of transformations.

1051


What is the procedure for creating independent data marts from informatica 7.1?

1060