Answer Posted / nagesh

No. Sourse Qualifier is a must for informatica mappings.
What the source qualifier does is, when we add a relational
or flat file source definition to a mapping, we need to
connect it to a Source Qualifier Transformation. The SQ
represents the rows that the Integration Service reads when
it runs in the session.Because we need to apply a business
logic in the staging area, the SQ allows us to access the
data and convert it into the informatica data types thro
respective transformations. Thus we will be able to apply
the business logic and transform the data to be compatible
with target database with the help of SQ.

How you can differentiate between connected lookup and unconnected lookup?

1064

---

Why do we need informatica?

998

---

How to partition the Session?

1114

---

How to extract the informatica rejected data?

1223

---

What is workflow monitor?

1062

---

What is the cumulative sum and moving sum?

1186

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107

---

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

1081

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1055

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1769

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1907

---

Define mapplet?

1016

---

Can we create a Integration service without a Repository service and vice versa?

1215

---

Explain the different kinds of facts.

984

---

What is complex mapping?

1125

---