Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
21 27475Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
3 8194Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
4 36328What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
CTS,
5 46250Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
CTS,
2 9232LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
6 23168How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
3 29269Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
1 5055There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
TCS,
9 14764Post New Informatica Questions
Which transformation is needed while using the Cobol sources as source definitions?
What are mapplets? How is it different from a Reusable Transformation?
What is a node in Informatica?
What does refresh system mean, and what are its distinctive choice?
tell me the rules and responsblites in our project(my project is development)
Whats there in global repository
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
Briefly describe lookup transformation?
Explain the different lookup methods used in informatica?
Define filter transformation?
Explain how many types of dimensions are available in informatica?
What is mapping debugger?
What is meant by pre and post session shell command?
What are the different components of powercenter?
Explain constraint based loading in informatica