what is lookup ?

Answer Posted / giri

Lookup connected,unconnected and Passive transformation. Looking for related values and inserting flake values.

Inserting Flag value

0 - No Change
1 - Insert
2 - Update

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain abt ur project architecture?

1732


Name at least 5 different types of transformations used in mapping design and state the use of each.?

643


server hot-ws270 is connect to Repository B. What does it mean?

1819


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

605


Explain pushdown optimization $pushdownconfig parameter - informatica

670






What are the prerequisite tasks to achieve the session partition?

680


Explain the use of aggregator cache file?

646


What is expression transformation?

611


Separate from a database, an information bazaar, and an information stockroom?

587


Can we get 1st record through Informatica(without sequence number).

940


rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

1504


How to load the data from a flat file into the target where the source flat file name changes daily?

554


Is it possible to use a client with different version than that of its Informatica server?

613


design of staging area?

1565


What are the performance considerations when working with aggregator transformation?

655