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.

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2552

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1261

---

What are the different transaction levels available in transaction control transformation?

1192

---

How to Create a folder using pmrep command?

1173

---

what is informatica metadata?

1028

---

What are the types of caches in lookup?

1046

---

Which files are created during the session rums by informatics server?

1175

---

how tokens will generate?

2195

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1118

---

State the limitations where we cannot use joiner in the mapping pipeline?

1060

---

Explain the different lookup methods used in informatica?

1037

---

Does an informatica transformation support only aggregate expressions?

1034

---

Explain the types of transformations?

1059

---

What are the guidelines to be followed while using union transformation?

1134

---

What are the different types of transformation available in informatica.

1101

---