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.

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,

---

What are the two modes of datamovement in informatica sever?

2 Answers  

---

How many number of sessions that u can create in a batch?

3 Answers  

---

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

Briefly describe lookup transformation?

0 Answers  

---

what is data driven?

1 Answers  

---

How many numbers of sessions can one group in batches?

0 Answers  

---

How can we handle two sessions in informatica?

0 Answers  

---