Answer / swetha

Parameter file is to define the values for parameters and
variables used in a session.A parameter file is a file
created by text editor such as word pad or notepad.

yoU can define the following values in parameter file

Maping variables

session parameters.

Answer / chandrasekar

Mapping Parameter is a constant value that can be defines in
before mapping run.

Mapping parameter file is created using Notepad or wordpad
with the extension of .txt or .prm.

If i wrong means mail to me chandranmca2007@gmail.com

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

difference between shortcut and reusable transformation?

2 Answers  

---

What is Session and Batches?

0 Answers   Informatica,

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

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

0 Answers  

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

where to select code page option?

2 Answers   TCS,

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---