Answer Posted / bsgsr

no using update strategy without primary keys update is not
possible. try and read teh session log file once. it will
display a msg updates are not supported without primary
keys.

update override in the target is to update the function in
the update strategy t/tion and it updates only on non-
primary key columns like dname, loc but not on deptno.

gilbert can i have your mail id here is mine
bsinivas1213@gmail.com
else call me on my num 9866188658 once v can have kt which
is mutually beneficial

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

1252

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1036

---

How can we improve session performance in aggregator transformation?

1097

---

What are some examples of informatica etl programs?

927

---

What is the surrogate key?

1248

---

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

2065

---

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

1078

---

What are multi-group transformations?

1081

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2100

---

explan ur project architecture?

2051

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1072

---

What is union transformation?

959

---

what is SDLC way of code development?

2035

---

Differences between connected and unconnected lookup?

1208

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1771

---