Answer Posted / karthik

$pmcmd is the command used to run workflow in UNIX environment.

pmcmd startworkflow -sv <server name> -d <domain
name> -u <user name> -p
<password> -f <folder name> <workflow name>

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

---

What's the layout of parameter file (what does a parameter file contain?)?

2387

---

How we can use union transformation?

1053

---

What are the settings that you use to configure the joiner transformation?

1055

---

without table how to come first record only in oracle?

2257

---

In informatics server which files are created during the session rums?

1118

---

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

1970

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

---

What is a router transformation?

1131

---

Describe the impact of several join conditions and join order in a joiner transformation?

1063

---

Explain dynamic target flat file name generation in informatica

1055

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2038

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

---

Mention a few design and development best practices for informatica?

999

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866

---