Answer Posted / babu

Hi Manoj,


Versioning option is available in below mentiond path.

Mapping designet==> versioning tab(Check In,Check Out,..)

if u have any dout,make a call to me i will give complete
deailed expelnation.

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2351

---

Explain joiner transformation in informatica

1123

---

tell me the rules and responsblites in our project(my project is development)

1931

---

Differentiate between joiner and lookup transformation?

1100

---

explain one complex mapping with logic? sales project?

6661

---

What is exclusive and normal mode for repository services?

1138

---

What is status code in informatica?

1015

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2035

---

What are the transformations that are not supported in mapplet?

1017

---

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

1964

---

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

1010

---

What is the function of aggregator transformation?

1080

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1086

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1902

---

How can we delete duplicate rows from flat files?

1215

---