Answer Posted / gopi

star schema
snow flae schema
hybrid schema
multistar schema

What are the types of caches in lookup? Explain them.

550

---

Did u used latest transformations of 8.6.0? for what?

1475

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1045

---

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

1527

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1632

---

---

Explain constraint based loading in informatica

657

---

is it possible to index the data in cache of lkp transformation ?

1523

---

What is a snowflake schema?

567

---

Explain the difference between a data warehouse and a data mart?

596

---

COM components can be used in Informatica

1873

---

What is joiner transformation in informatica?

625

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3508

---

whats the logic to load the lower level of granularity of data to fact table.

1793

---

What are the different versions of informatica?

676

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1697

---