Answer Posted / vishnu_kr

Hi,

i guess the SQL override is used in the source qualifier trf
to implement joins, filter, sorter etc..

but update override is used in the Target table definition.
u use this option to update Targets that have no primary
key (hence u can't use update strategy) coupled
with 'Update as update' property in the session mappings tab
and 'Treat rows as' property set as 'Update' in the session
Properties tab.

Is there any way to read the ms excel datas directly into informatica?

1067

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2070

---

What is the session task and command task?

1114

---

Is there any target staging area in informatica not staging area

2631

---

How does a sorter cache works?

1109

---

Make a note of the quantity vaults made in informatica?

1043

---

How do we call shell scripts from informatica?

1190

---

What are the main issues while working with flat files as source and as targets ?

1216

---

How to create the source and target database connections in server manager?

1130

---

explain about unit testing? in real time?

2265

---

How many number of sessions can one group in batches?

1215

---

what is the -ve test case in your project.

2458

---

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

1916

---

What is parallel processing in informatica?

1789

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2186

---