Answer Posted / krishna

select * from (select distinct name male from fm where
gender='male'),(select distinct name female from fm e
where gender='female');

select decode(gender,'female',name)female,decode
(gender,'male',name)male from fm ;

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.

1652

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2009

---

How many input parameters can exist in an unconnected lookup?

1517

---

How do you update the records with or without using update strategy?

1081

---

Mention few power centre client applications with their basic purpose?

915

---

Explain lookup transformation source types in informatica

1066

---

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

1191

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2098

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1820

---

tell me 5 session failure in real time how can you solve that in your project?

2232

---

What is the sql query overwrite in source qualifier in informatica

1053

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1593

---

How can we delete duplicate rows from flat files?

1189

---

Why update strategy and union transformations are active? Explain with examples.

1205

---

Explain how many types of dimensions are available in informatica?

1049

---