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.

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

which one is better performance wise joiner or look up

1 Answers   Informatica,

---

What are mapplets?

1 Answers  

---

lookup transformation with screenshots

1 Answers   TCS,

---

Differences between connected and unconnected lookup?

1 Answers  

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

What are the informatica performance improvement tips

1 Answers   Informatica,

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

2 Answers   IBM,

---