Answer Posted / mithilesh kumar rai

There r 9 types of files informatica server generating.
1. BadFiles
2. Cache
3. ExtProc
4. LkpFiles
5. SessLogs
6. SrcFiles
7. Temp
8. TgtFiles
9. WorkFlowLogs

What are the transformations that are not supported in mapplet?

1004

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2040

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10666

---

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

1956

---

What are the new features of Power Center 5.0?

1754

---

COM components can be used in Informatica

2368

---

Why is sorter an active transformation?

1101

---

What is an aggregator transformation?

1087

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1174

---

Can we get 1st record through Informatica(without sequence number).

1460

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1653

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2336

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7358

---

State the limitations where we cannot use joiner in the mapping pipeline?

1043

---

What is session task and command task?

1264

---