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 a look up function? What is default transformation
for the look up function?

Question Posted / swetha

Answers were Sorted based on User's Feedback



What is a look up function? What is default transformation for the look up function?..

Answer / sri

Lookup is a transformation in Informatica which is mainly
used for obtaining the "Key" values from the dimensions.
Lookup can be connected or unconnected. If it is
unconnected then it can be used as a function but it can
return only one value.
Where as connected lookup return more than one value.
Lookup contains:
1. <Input Column/Value>
2. <Output Column(s)>
3. <Condition>

Is This Answer Correct ?    12 Yes 4 No

What is a look up function? What is default transformation for the look up function?..

Answer / guest

look up compares the source to target.it update and insert
the new rows to the target.

the default transformation for look up is source qualifier

Is This Answer Correct ?    13 Yes 9 No

Post New Answer

More Informatica Interview Questions

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

How to update source definition?

0 Answers  

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

difference between stop and abort

2 Answers  

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

comonly how meny mappings r there in Banking projects?

1 Answers  

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

For more Informatica Interview Questions Click Here
Categories