Answer / swetha

Maping: It is a set of source and target definitions linked
by transformation objects that define the rules for
transformation.

Session : It is a set of instructions that describe how and
when to move data from source to targets.

Answer / suresh

MAPPING: it is a graphical representation of data flow from
source to target which included some business
transformation logic

SESSION: It is a set of instructions that describe how and
when to move data from source to targets.

Answer / surya

Mapping:When a Source definition transformation and Target
definition transformation are connected in a sequence
through a ETL follow of data.Such a sequence is called
Mapping.

Session:It is a task,used to migrate the data from source
to target using some instructions by informatica server is
called Session.

How does the session recovery work.

1 Answers  

---

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

---

Is stop and abort are same in informatica?

0 Answers  

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

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  

---

What is up date strategy and what are the options for update strategy?

2 Answers  

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

What is meant by pre and post session shell command?

0 Answers  

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---