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 >> ETL
  2. Suggest New Category

when should one create lookup transformation ?

Question Posted / jakki

Answers were Sorted based on User's Feedback



when should one create lookup transformation ?..

Answer / murthy

generally lookup is used to search for a record.in realtime
mainly people use this to fetch the key values doing a
lookup on the other table.

Is This Answer Correct ?    3 Yes 0 No

when should one create lookup transformation ?..

Answer / kaki

Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More ETL Interview Questions

What are the three tiers in etl?

0 Answers  

Explain about etl data integration software?

0 Answers  

How to Check the source record count from traget table.

5 Answers   IBM,

what is session partitioning?

0 Answers  

Can u access a repository created in previous version of Informatica?

1 Answers  

how do u automate Extraction process?

1 Answers  

Explain the use lookup tables and Aggregate tables?

0 Answers  

What are snapshots?

0 Answers  

What is lookup table in etl testing?

0 Answers  

Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  

where is the cache (lookup, index) created and how can you see it.

0 Answers  

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,

For more ETL Interview Questions Click Here
Categories