Answer Posted / ganesh yadav

source->source.Qul->expres.Tran->target table
in the target desiner select target type as Flat File.

if u want only Header of the table with out data also we can do..

What is the difference between informatica 7.0 and 8.0?

1051

---

Which version configuration tool used in ur project?

3321

---

What is sorter transformation?

1108

---

Can you use flat files in Mapplets.

2713

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5789

---

What are multi-group transformations?

1165

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2127

---

How to generate sequence numbers without using the sequence generator transformation?

1258

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1799

---

Tell me about MD5 functions in informatica

983

---

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

---

Explain target update override in informatica

1190

---

What is Data Caches size?

1128

---

What can we do to improve the performance of informatica aggregator transformation?

1142

---

What are the types of data warehouses?

1576

---