Interested to Buy Any Domain ? << Click Here >> for more details...
What is exact use of 'Online' and 'Offline' server connect
Options while defining Work flow in Work flow ?
- 1 Answers
- 5319 Views
- I also Faced
- E-Mail Answers
Answer Posted / dheebalakshmi
When the repo is up and PMSERVER is also up, workflow
monitor always will be connected online
When PMSERVER is down and the repo is still up we will be
prompted for an offline connection with which we can just
monitor the workflow
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is sorter transformation?
How an expression transformation differs from aggregator transformation?
What are data-driven sessions?
How to create a non-reusable instance of reusable transformations?
Informatica settings are available in which file?
What is primary and backup node?
What do you mean incremental aggregation?
How you prepared reports for OLAP?
State the differences between sql override and lookup override?
Define joiner transformation?
list out all the transformations which use cache?
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
What are the basic requirements to join two sources in a source qualifier transformation using default join?
