Answer Posted / subramanyam
A key that uniquely identifies rows in a table. Any of the
identified candidate keys can be used as the table's
primary key. Any of the candidate keys that is not part of
the primary key is called an alternate key. One can
describe a Candidate Key as a Super Key that contains only
the minimum number of columns necessary to determine
uniqueness.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What do you mean by channel change?
What is the benefit of partitioning a session?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What do you understand by a term domain?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is a sorter transformation?
What is the sql query overwrite in source qualifier in informatica
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
What is a sequence generator transformation?
What is pmcmd command?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How to do unit testing in informatica?
What is sq transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?