what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2339

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1052

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1267

What is incremental aggregation?

1084

While migrating the data from one environment to another environment how would you manage the connections?

1090

How to extract sap data using informatica? What is abap? What are idocs?

1182

What are active transformations.

1654

What are mapplets? How is it different from a Reusable Transformation?

1090

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

1970

Under which circumstances, informatica server creates reject files?

1095

where to store informatica rejected data? How to extract the informatica rejected data?

1005

What is a filter transformation?

1043

How are indexes created after completing the load process?

1644

What is a repository? And how to add it in an informatica client?

1149

Write the different tools in the workflow manager?

1066