Answer / pavani

STOP command instructs Integration Service to STOP reading
input but still continues with processing and commiting.
wherein ABORT has 60 seconds timeout period after which it
kills the process

Answer / ratnesh

Stop:will stop reading data from source , continue to process of write and commit
Abort : same as stop , additional has 60 second time period.

Answer / umamahesh

The STOP option is used to execute the session task and
allow other task to run, whereas ABORT option completely
turns off the task that is running.

- When using STOP option the integration services stop
reading the data from the source of the file, whereas ABORT
waits for the services to be finished and then only any
actions take place.

- The STOP command processes the data to the source or to
targets, whereas ABORT option has the timeout period of 60
seconds.

- STOP option allows the writing of the data and committing
the data to the targets, whereas ABORT shows no commitment
as such.

- STOP option doesn’t kill any process and it just stops the
resource sharing between the processes, whereas ABORT stops
the process and the session gets terminated.

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  

---

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

0 Answers  

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

---

explain about session partitions ?

1 Answers  

---

What is meant by pre and post session shell command?

0 Answers  

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---