Answer Posted / ram reddy

Update Override it is an option available in TARGET
instance.By defalut Target table is updated based on
Primary key values.To update the Target table on non
primary key values u can generate the default Querey and
override the Querey according to the requiremnet.Suppose
for example u want to update the record in target table
When a column value='AAA' then u can include this condition
in where clause of default Querey.

Coming to SQL override it is an option available in Source
Qualifier and Lookup transafornmation where u can inlude
joins ,filters,Group by and order by.

What is the function of union transformation?

1072

---

What are junk dimensions?

1032

---

How many ways a relational source definition can be updated and what are they?

966

---

How you prepared reports for OLAP?

1560

---

Explain the informatica workflow?

1014

---

Write the unconnected lookup syntax and how to return more than one column.

1065

---

Enlist some properties of sessions.

1031

---

what is the -ve test case in your project.

2347

---

How to do unit testing in informatica?

1130

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1905

---

What is a rank transform?

1040

---

What is repository manager?

940

---

What is olap (on-line analytical processing?

1017

---

What do you understand by SOA of Informatica?

933

---

How to extract the informatica rejected data?

1169

---