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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is the look up transformation?

Question Posted / swetha

Answers were Sorted based on User's Feedback



what is the look up transformation?..

Answer / ashis

Add to sweta's answer:

We use lookup transformation to lookup data from a
relational table, view, synonym or flatfile against another
or the same table, view, synonym or flatfile.

This is mainly(not only)used for SCD's. So that the value
in the source can be compared with the existing target.

Lookup transformation are of different types named and
unnamed.

Mostly used lookup transformation types are Connected lookup
(Persistent Lookup, Dynamic lookup, Cached lookup, Uncached
lookup)

Is This Answer Correct ?    7 Yes 2 No

what is the look up transformation?..

Answer / swetha

Use lookup transformation in u'r mapping to lookup data in a
relational table, view, synonym.

Informatica server queries the look up table based on the
lookup ports in the transformation. It compares the lookup
transformation port values to lookup table column values
based on the look up condition.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

in performance wise union is past,union all is past

2 Answers  

What are the challenges of Dataware housing in the future?

2 Answers   HP,

what is confirmed fact?

2 Answers  

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

how do u move the code from development to production?

3 Answers  

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,

What are the different versions of informatica?

0 Answers  

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

Design time, run time. If you don't create parameter what will happen

0 Answers  

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories