Answer Posted / balanri

Hi,

Log Files : Log files are files that contain messages about
the system, including the repository, services, and
applications running on it.

Storage : Workflow Log File Directory=> Location for the
workflow log file. By default, the Integration Service
writes the log file in the process variable directory,
$PMWorkflowLogDir.
If you enter a full directory and file name in the Workflow
Log File Name field, clear this field.

Log Files are used to trace the session or workflow run.,
provides ease of tracking the compilation of design.

Thanks,

What is workflow? What are the components of the workflow manager?

1169

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1158

---

Repository user profiles

1811

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1164

---

what is unit testing?tell me proceedure

2272

---

What is the benefit of partitioning a session?

1235

---

How does a sorter cache works?

1109

---

expain about the tune parameters?

2457

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1165

---

What are the components of Informatica? And what is the purpose of each?

1108

---

What are ETL Tools?

1170

---

State the limitations where we cannot use joiner in the mapping pipeline?

1106

---

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

2009

---

What is dimensional table?

1131

---

explain about unit testing? in real time?

2265

---