Answer / gyana

data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..

Answer / gyana

data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..

Answer / pradosh ranjan swain

data driven is the session property.which tell the user to do
the operations on data as per the update strategy
transformation used in mapping..
As the the requirement we define the proprertie in session level for the
Update strategy transfermation like Inser,delete,update..

Answer / gyana

data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..

Answer / gyana

data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..

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  

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

how to create user defined function (udf) in informatica

0 Answers   Informatica,

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

what is mystery dimension?

1 Answers  

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

How do you take care of security using a repository manager

2 Answers  

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

What is the difference between informatica 7.0 and 8.0?

0 Answers  

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,