Answer Posted / nagarau puppala

select distinct country_id "unique", (case when count(country_id) > 1 then country_id else null end) "duplicate" from s_region
group by country_id order by duplicate;

Can we create a Integration service without a Repository service and vice versa?

1257

---

What are the components of the workflow manager?

1181

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2105

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1306

---

What is the difference between informatica 7.0 and 8.0?

1051

---

What are data-driven sessions?

1261

---

Separate from a database, an information bazaar, and an information stockroom?

1129

---

What is the difference between informatics 7x and 8x and what is latest version?

1137

---

what is Active lock explain

2857

---

Where are the source flat files kept before running the session?

1138

---

write a query to retrieve the latest records from the table sorted by version(scd)

1114

---

What is meant by lookup transformation?

1181

---

What is the way to execute pl/sql script using informatica mapping?

1681

---

Which is the t/r that builts only single cache memory?

1238

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2443

---