Answer Posted / pooja

YES WITHOUT A pk WE CANT UPDATE THE REC....

IN SESSION PROPERTIES WE HAVE ONE OPTION TREAT ALL ROWS
AS... THERE U SELECT UPDATE OPTION AND IN THE TARGET
PROPERTIES SELECT UPDTAE OPTION

explain about unit testing? in real time?

2179

---

How can you generate reports in informatica?

1004

---

Explain dynamic target flat file name generation in informatica

1034

---

what is index?how it can work in informatica

2027

---

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.

1678

---

can u give example for factless fact table

6596

---

What is rank transformation?

970

---

What is informatica powercenter repository?

1171

---

What is a repository manager?

1076

---

What are the differences between source qualifier and joiner transformation?

1035

---

How can we update a record in the target table without using update strategy?

1121

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1560

---

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

2025

---

Slowly changing dimensions, types and where will you use them

1688

---

What is the need of an ETL tool?

1070

---