Answer Posted / srinu

When we don't have primary keys defined on database level.
And still we need update on this target from Informatica.
We neeed to define keys at informatica level and use update
override in target property. This way we can update the
table.

<source>-geekinterview.com

Any Queries or Corrections
srinu.srinuvas@gmail.com

What is the surrogate key?

1264

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6183

---

What is native users?

1168

---

What's the layout of parameter file (what does a parameter file contain?)?

2386

---

Explain Dataware house architecture .how data flow from intial to end?

2585

---

Design time, run time. If you don't create parameter what will happen

1837

---

What is a connected transformation?

1120

---

Which are the different editions of informatica powercenter that are available?

1034

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1323

---

How do you load unique records into one target table and duplicate records into a different target table?

1261

---

Explain scd type 3 through mapping.

1011

---

What is decode in informatica?

1165

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2861

---

What can we do to improve the performance of informatica aggregator transformation?

1095

---

where to store informatica rejected data? How to extract the informatica rejected data?

1007

---