Answer Posted / ramanaidu kolli

One project developed in old version (informatica 6.1)in
earlier now we need to add a new fields in target database
columns but now we are using (informatica 8.6 version) so
client requirement need to transfer data Earlier version to
New Version in this scenario we are using Version control
option

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1219

---

How can repository reports be accessed without sql or other transformations?

1177

---

Can u generate reports in Informatica?

1042

---

In development project what is the process to follow for an etl developer from day1

1673

---

What is the need of etl tools?

1071

---

Target increases every day even though no new record was inserted

1527

---

Explain what transformation and how many are there in informatica?

905

---

Write the different tools in the workflow manager?

1015

---

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

1940

---

What is substr in informatica?

1153

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2008

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2087

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2083

---

What is joiner change?

1100

---

What is a router transformation?

1070

---