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.

Explain the tuning lookup transformation - informatica

988

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1103

---

Performance tuning( what you did in performance tuning)

1975

---

What is difference between a gateway node and worker node?

1133

---

What is rank transform?

991

---

Explain sql transformation in script mode examples in informatica

1127

---

What is sequence generator transformation in informatica?

1072

---

What is depict expression change?

1112

---

Where are the source flat files kept before running the session?

1067

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1197

---

What are the databases that informatica can connect to windows?

1044

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1051

---

what is the size of your data warehousing?

2091

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2162

---

What is a transaction control transformation?

1204

---