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.

What is the session task and command task?

1061

---

Do you find any difficulty while working with flat files as source and target?

1098

---

What is an expression transformation in informatica?

1040

---

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

1202

---

What are mapplets? How is it different from a Reusable Transformation?

1092

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1582

---

what is index?how it can work in informatica

2041

---

What does reusable transformation mean?

1133

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1080

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2137

---

Explain pushdown optimization and types in informatica

1079

---

How can a transformation be made reusable?

1171

---

What is lookup change?

1049

---

Can we get 1st record through Informatica(without sequence number).

1479

---

How to do unit testing in informatica? How to load data in informatica ?

1121

---