Answer / indira meduri

Erwin is a Data Modeller tool. It is almost like MS Visio.

we can create a Logical or Physical database using this
tool. This tool shows a broad view of how tables are
connected to each other with their relationships too.

Well we can also create a brand new database schema or even
reverse engineer an existing schema too.

Informatica is an ETL tool.

Answer / nag

Hi,

Hi Erwin is a Data Modeling tool and Informatica is a ETL
Tool. These two are different tools. But after doing data
modeling in Erwin , Informatica come into picture. Business
Objects comes after the ETL Developer part is completed.

Business Objects is a reporting tool. It takes the reports
from the datawarehouse.

This is as per my knowledge.

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

---

how do u tune queries?

1 Answers  

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

How to delete duplicate records in a flat file source?

2 Answers  

---

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

---

what is left outer join?

3 Answers   L&T,

---

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  

---

How many number of sessions that u can create in a batch?

3 Answers  

---

How to generate the HTML output using Informatica.

3 Answers   Wipro,

---

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---