Answer Posted / ashish

In addition to the Aruna's answer,Integration service require native datatypes and SQ convert the port in to native datatypes to make the data compatible with Integration service.
for Eg. In source table if a column's datatype is "Varchar2" then source qualifier will convert it in "String" type.

list out all the transformations which use cache?

1111

---

Is it possible to revert a global repository to local one and why?

1021

---

What is the difference between informatica 7.0 and 8.0?

951

---

What is a difference between complete, stop and abort?

1028

---

Did u used latest transformations of 8.6.0? for what?

1821

---

Does an informatica transformation support only aggregate expressions?

965

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1949

---

How to create or import flat file definition in to the warehouse designer?

1018

---

What can we do to improve the performance of informatica aggregator transformation?

1041

---

wat are deployement groups in informatica, how it will be used for developers

1667

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1968

---

What is a joiner transformation?

935

---

What is the status code in stored procedure transformation?

1118

---

What is the fact table?

991

---

How many input parameters can exist in an unconnected lookup?

1489

---