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 are the reusable transformations?

1170

---

Explain sessions and how many types of sessions are there?

1014

---

How to elaborate tracing level?

1188

---

lookup transformation with screenshots

4012

---

what is the complex transformation you used in informatica

2594

---

What is domain and gateway node?

1173

---

What is a rank transform?

1093

---

Please let me know how to make Data masking in informatica..

1737

---

What is the Process to creating lookup transformation in informatica

1053

---

How does the aggregator transformation handle null values?

1154

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1692

---

Which development components of informatica have the highest usage?

1066

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1686

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1805

---

How can repository reports be accessed without sql or other transformations?

1233

---