Answer / kunal

1) SQ Override- In case of SQ override the unwanted columns
are filtered out and the required columns based on some
filter condition returned as an input to the next
transformation.
LKP Override- In case of LKP override, look up conditions
are checked and the records passed to next
transformation.Look up override can be applied on source or
target table.
2) In case of SQ override user has to mention order by
clause when required.
In LKP override the look up trans. internally apply order
by clause and if user want to use order by clause, user has
to mark '--' to disable the lkp order by clause.

Answer / siddardh

Both are same, which means you are writing the query which
will override informatcica generated query.

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

---

What are roles and groups and benefits of using them?

0 Answers  

---

Why we need XMLs?

3 Answers   IBM,

---

How does the session recovery work.

1 Answers  

---

What is different between the data warehouse and data mart?

0 Answers  

---

---

what we require for D.modelling?

1 Answers  

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

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

0 Answers  

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

How to update a particular record in target with out running whole workflow?

0 Answers  

---

permutations of mapplet

0 Answers   TCS,

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---